Unanswered

parsing text from email's body with same tag's title and different values

(0) Share

Report

Posted on by gennarodp

294

Hi, I would like to parse the text from a following type of text_



Part number: AAA000



Description: Test1



Qty: 10



Part number: BBB000



Description: Test2



Qty: 5



Part number: CCC000



Description: Test3



Qty: 12





I would like a function that would pass the text of each part number and not just the last one.



The output I would like to have is:



Part number 1: AAA000

Part number 2: BBB000

Part number 3: CCC000



It's possible?

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (2)

v-bofeng-msft on at

Like (0)

Report

Hi @gennarodp :

I noticed that each line is separated by 3 lines. I don't know if this is a format problem when inputting.

I assume that the real format of this string is:

Part number: AAA000

Description: Test1

Qty: 10

Part number: BBB000

Description: Test2

Qty: 5

Part number: CCC000

Description: Test3

Qty: 12

If so, please try this flow:

1\My entire flow

Step1:create three variables

Step2:Do until

Reference Expression:

1\ div(length(Split(uriComponentToString(replace(uriComponent(variables('TheString')), '%0A', '/n')), '/n')), 3)

2\ Split(Split(uriComponentToString(replace(uriComponent(variables('TheString')), '%0A', '/n')),'/n')[sub(mul(variables('count1'),3),3)],':')[1]

The Result

In addition,There is also a relatively simpler way to split a string by line.

The point is to create A string whose value is a carriage return.

note:Enter a carriage return in the place I marked

Then-Do until

Reference Expression:

1\

div(length(split(variables('TheString'),variables('blank'))), 3)

2\

Split(split(variables('TheString'),variables('blank'))[sub(mul(variables('count1'),3),3)],':')[1]

Best Regards,

Bof

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

Hello Bof,
thanks for wour answer.

You are very great with Power Automate !!

In the Step1, you in "Inizialise variable", you insert text of mail including part numbers example (AAA000, BBB000, CCC000).

Those values, are variable, and are not the same, in the different emails that i receive.

Could explain me better this step ?

Thanks

Regards

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

Hello Bof,
i give you more elements.

In specific, the text is similar to this:

testxtestxtestxtestxtestx
testxtestxtestxtestxtestx

Part Number: AAA000
Description: Test1
Qty: 10

testxtestxtestxtestxtestx
testxtestxtestxtestxtestx

Part Number: BBB000
Description: Test2
Qty: 20

testxtestxtestxtestxtestx
testxtestxtestxtestxtestx

Part Number: CCC000
Description: Test3
Qty: 4

Is there a method to extract in the text only the all strings that starts with "Part Number:" ?

And then order those strings in:
Part Number1
Part Number2
PartNumber3

Thanks

Regards

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

Although it is possible to do this with with excellent help @v-bofeng-msft has given you, for emails like this, I would suggest taking a look at mailparser.io and using that to parse your email. It is so easy to do.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @gennarodp :

Just add a variable named blank, and then modify the two Expressions.

Please try this:

note:The omitted steps are in my previous soltuion

1\

sub(length(split(variables('TheString'),'Part number:')),1)

2\

Split(split(variables('TheString'),'Part number:')[variables('count1')],variables('blank'))[0]

The Result

Best Regards,

Bof

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

Hello @v-bofeng-msft ,
thank you for your answer.

But the space in the email can be variable, and the number of part number is variable (can be three, but also four, or one).

For those reasons, i have asked you an variable that i use only when the field "Part Number" is find.

Thank you very much.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @gennarodp :

I have improved the scheme. The problem you mentioned does not affect anything, you can test it.

Test text:

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @gennarodp :

The value of TheResult is blank when it is initialized, no need to fill in.

Best Regards,

Bof

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

Hello Bof,
thanks for yourn answer but doesnt't work 😞

It extract to me only the first Part Number, and not others two.

What could be the problem?

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

Update: ok, it worksssss !!!!

But the result is not fine separated:

The result is as:

Part Number 1 : AAA000Part Number 2 : BBB000Part Number 3 : CCC000

How is there error ?

Why doesnt' separate it correctly ?

Was this reply helpful? Yes No