Data extraction from text to excel

Help Studio
1

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 :

2

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

2 Likes
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…

2 Likes
4

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
5

ohk ,i will try thanks for help

1 Like
6

yahhh

7

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