Regex expression to fetch only data from below text?

Data:
Document Number Amount Date TDS/Deduction Net Amount Narration/Inv No
Amount
| 805G-EYLS- | INR 110489.oo| 25/04/2018 | 9364.00’ 101125.oo| TL29T18/2429 |

Expected results:
Full Match should be | 805G-EYLS- | INR 110489.oo| 25/04/2018 | 9364.00’ 101125.oo| TL29T18/2429 |
Group 1: 805G-EYLS-
Group 2: 110489.oo
Group 3: 25/04/2018
Group 4: 9364.00
Group 5: 101125.oo
Group 6: TL29T18/2429

(\d)+(.oo)

(\d)+(.00)

(\d)+/(\d)+/(\d)+

((\w)+(-))+

(\w){3,}(/)(\d)+

Note:
If you need every thing in one regex then

((\w)+(-))+|(\d)+(.oo)|(\d)+(/)(\d)+(/)(\d)+|(\d)+(.00)|(\w){3,}(/)(\d)+

Keep this regex in Matches activity that will return you an array you can iterate and get the output.
hope that helps
Ashley Nihal Dcunha

2 Likes

Thanks you:-)

1 Like

did that work?
Is your problem solved?

Yes it worked thanks so much:-)

1 Like