Regex and multi-row formula help?

[bzeringue]

Hello Community!

Looking for help with Regex expression and possibly multi-row formula tools.

I have attached the input data and then what I am wanting.  Don't know if this is possible, but any suggestions are appreciated!

Basically looking to carve out the invoice number and then the associated customer name associated with the invoice number.

Thanks

[binu_acs]

@bzeringue Can you provide the input file?

[Felipe_Ribeir0]

Hi @bzeringue 

Try to adapt the attached workflow.

[bzeringue]

Input file attached.

[bzeringue]

Felipe,

I will try this and report back.

Thanks!

[bzeringue]

I get the following parse error when I try to use my input file.  Workflow attached.

[flying008 · Accepted solution]

Hi, @bzeringue 

Another way for you :

[ArnaldoSandoval · Accepted solution]

Hi @bzeringue 

My workflow gives you another way to process your Invoice Register Detail; It parses the data in Header-Details and fields, the report data is organized in 3 sections (excluding report headers): Customer Record (this is the header); Detail Records (one to many per Customer) and Totals; my logic exclude the total and empty lines founr on the report, it generates two outputs, the first is the whole Customer-Orders Details, the second is the Customers-Orders Numbers.

Now, you can compare multiple techniques.

Hope this helps,

Arnaldo

[bzeringue]

This is fantastic!  Thank you guys so much.  Love the 2 outputs, @ArnaldoSandoval !