How to extract cat number and line item number from invoice data in to excel file

Help
1

Hi,

We have a text file with invoice data, we need to extract Line item number and cat number from text file in to excel.

Please help us with this scenario.

Thtest to Excel.zip (1.4 KB)
anks,
Mounika

2

If your text file comes with proper format then you can use regex to get item number and cat number from the text file.
To do so you can simply read the entire text file and use the output string to apply regex for getting desired values.

Once you are done with fetching proper values from the text file, you can add them to excel by using add data row.