How to extract certain parts of a string

Like (0) Share

Report

Posted on 13 Jul 2022 11:13:25 by ultrAslan

100

Hello,

I have a string of that I've extracted from AI Build (model: Extract information from invoices) to Text.

I need to create an expression that pulls numbers which begin with "111" or "222".

Example String:

111523 o 78 i 23
Text Text 12 o a & #,
xyz abcdfgh 123
aaa bc 1 # , 222423
xyz 1
Text Text Text

Expected Result:

111523 222423

____________________________________________________________________________
How to build a compose so that I only got the 111... & 222... numbers?*
I tried split() Function but with that I was not able to solve this.

split(triggerBody()[‘text’],’111’) - with that I only separate the number 111 but I want to separate the whole number beginning with 111 (or 222).

Any ideas?
Thank you!

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

shoog 2,164 on 15 Jul 2022 at 06:19:11

Like (0)

Report

Re: How to extract certain parts of a string

@ultrAslan Do you need further help on this?

If the suggested solution is working as expected, then please mark it as solution accepted. This will help others in the community looking for solutions.

Was this reply helpful? Yes No
Verified answer

shoog 2,164 on 13 Jul 2022 at 11:24:07

Like (2)

Report
Re: How to extract certain parts of a string

You can use the Filter array action. For the From argument: split(inputstring, ' ')

for the filter condition

<at>or(startsWith(item(), '111'), startsWith(item(), '222'))

substitute <at> with the @ sign and inputstring with the output of the extract action.

Was this reply helpful? Yes No