cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
MVP

Re: Extract Information from a String

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
MVP

Re: Extract Information from a String

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

Highlighted
New Member

Re: Extract Information from a String

Sandy, 

thank you. That works great!

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,106)