Hello, I wanted to know how you extract and match data from text files to a data table so you can use it later to write down on an Excel File.
what I’m trying to do is to go through these text files, see if there is a mention of word “Invoice” if yes, get the “Invoice Number” with the file name and write it down in a xlsx file.
I was trying to use the “is Text Matching” Activity (and it failed) but Im not sure if this is the best way.
I do appreciate any help for this matter, thank you !
