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
Solved! Go to Solution.
@bzeringue Can you provide the input file?
Felipe,
I will try this and report back.
Thanks!
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
This is fantastic! Thank you guys so much. Love the 2 outputs, @ArnaldoSandoval !