Unanswered

Extract first few characters of a string

(0) Share

Report

Posted on by F_Quint

257

I have a field for which I want to extract the first few characters of a string which are always followed by an underscore character (_). The length of the string is variable but what I'm interested in extracting is what precedes the underscore.

for example, my string could be:

xyz_Company1

or it could be

QRS STUVWXYZ_Company2

how can I extract for these examples only xyz and QRS STUVWXYZ

thank you for your help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Re: Extract first few characters of a string

Like this:

The expression in the compose action is:

substring(variables('stringToSearch'),0,indexOf(variables('stringToSearch'), '_'))

And the output of the compose step is what you are after:

Was this reply helpful? Yes No
F_Quint 257 on at

Like (0)

Report

Re: Extract first few characters of a string

@Paulie78 thank you so much. That's exactly what I was after!

Was this reply helpful? Yes No