Data extraction from text to excel

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:

2 Likes

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ā€¦

2 Likes

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

1 Like

ohk ,i will try thanks for help

1 Like

yahhh

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.