I have one text file , I want data like Invoice Number 108027883 Document Number5001211394,Document date28/12/2020 ,Invoice Amount486167.80,Deductions 0.00 and Net Amount486167.80 like this data in excel in diffrent column.pls help me if u know. text.txt (570 Bytes) text file is :

Hi @sayali_rokade ! A way is to use regex, @prasath17 masters it: would you mind helping us ? :grin:

Oh great ! Did not notice duplicate topics haha, then @sayali_rokade would you mind closing this topic to not focus anymore on this topic ?

ohk ,i will try thanks for help

Data extraction from text to excel

prasath17 (Guru) April 9, 2021, 9:22pm 3

Hi @Hiba_B … To be honest, I am still the learner…as you know there are real masters out here…

I think this is the duplicate of the below post, where I have provided the solution this morning…

Topic		Replies	Views
PDF content in to in to excel table Studio uiautomation	6	2160	April 24, 2021
Regex pattern needed to extract invoice numebrs after reading PDF text Activities pdf , regex	8	1796	February 19, 2021
Text to excel- Data manipulation using Regex(VB code) Activities excel , pdf , question	8	1372	March 15, 2021
Extract invoice data from pdf to excel Help	5	1919	September 27, 2019
Help Invoice Extraction Studio studio , question	1	419	March 14, 2023