cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bsa1975
New Member

Extract Information from a String

Anybody an idea how to extract informations from a string?

 

My String looks like follow:

"OELGA ON LOWG 01/26 0127Z ON RPT DEP: LOWW - 4 VIENNA DEST: LOWG - GRAZ"

 

The following function finds "DEP:" in the string but takes the 4 Digits form the beginning of the string.

Output: "ELGA"

I would need the 4 Characters after the found "DEP:"...

utput should be: "LOWW"

if(contains(body('Html_to_text'), 'DEP:'),substring(body('Html_to_text'),1,4),'')

 

1 ACCEPTED SOLUTION

Accepted Solutions
SandyU
MVP

Hi @bsa1975

 

Your substring function is returning a string beginning at index 1, which is the 2nd character (the first character has an index value of 0), hence you're getting ELGA. So what you want to do is find a way for the substring to begin just after 'DEP:'

 

Here's a function that should work for you:

if(contains(body('Html_to_text'), 'DEP:'),substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'DEP:'),5),4),'')

 Here's what this does, reading sort of from the inside of the expression outward:

indexOf(body('Html_to_text'),'DEP:') finds the index location of the beginning of the DEP: string (which I'm assuming would only occur once). In your sample string, that index would be 33.

add(....,5) adds 5 to that index number, because you want the string which begins after DEP:[space]  - In your sample that's 38.

substring(body('Html_to_text'),...,4) returns a string from your input string which begins at index 38, and returns 4 characters, hence in this case LOWW.

 

Does that make sense...? I hope this will help you with using string functions in general - they're quite powerful!

 

Sandy

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

2 REPLIES 2
SandyU
MVP

Hi @bsa1975

 

Your substring function is returning a string beginning at index 1, which is the 2nd character (the first character has an index value of 0), hence you're getting ELGA. So what you want to do is find a way for the substring to begin just after 'DEP:'

 

Here's a function that should work for you:

if(contains(body('Html_to_text'), 'DEP:'),substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'DEP:'),5),4),'')

 Here's what this does, reading sort of from the inside of the expression outward:

indexOf(body('Html_to_text'),'DEP:') finds the index location of the beginning of the DEP: string (which I'm assuming would only occur once). In your sample string, that index would be 33.

add(....,5) adds 5 to that index number, because you want the string which begins after DEP:[space]  - In your sample that's 38.

substring(body('Html_to_text'),...,4) returns a string from your input string which begins at index 38, and returns 4 characters, hence in this case LOWW.

 

Does that make sense...? I hope this will help you with using string functions in general - they're quite powerful!

 

Sandy

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Sandy, 

thank you. That works great!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (17,462)