Expression for returning a Line of Text

[kerryniester]

Just started working with PA today and am primarily working on moving email order data to Excel. I've set up Excel table and have been able to link a number of items through expressions into the Live Excel Table. But I'm having difficulty figuring out additional data expressions that I need from the body of the email. Here is my general setup right now.

I'm trying to return the line of text that says "HC1 PLUM CREEK" but I cannot figure what expression I need to use:

Please advise on the correct expression. I know it's simple, but I can't figure it out. Thanks in advance!

[VictorIvanidze]

Hi @kerryniester,

why do you need this string but not another? How a string  you want to get differs from any other one?

In other words: how to define "order data"?

[Heartholme]

Hi @kerryniester ,

This should do the trick:

Use filter array to extract the line you want, with the following code: @contains(item(), 'HC1 PLUM CREEK') , remember to switch to advance mode in the filter array, where the green line in screenshot is:

This will give the following result:

{ Please click Accept as solution ✔ if my post answered your question. }
{ This will in turn help others find solutions to similar questions. }

Best Regards
Heartholme