I want some help in regex My input is
INV REF POST DATE DESC INV DATE GROSS AMOUNT TDS Amount
47094629 16/06/2023 AS PARTS 10/06/2023 2065.81 -2.00 2063.81
47868528 14/06/2023 AS PARTS 10/06/2023 3626.35 -3.00 3623.35
47264525 14/06/2023 AS PARTS 10/06/2023 308383.39 -262.00 308121.3
I want output from all three 1 element 47094629 2.00 2063.81 I have mentioned all three in a bold
There are only two things in bold here which is the third one ?
You can use the below regular expressions
Hope it helps!!
Thanks I will do 3 one by my own
If my solution has helped you kindly mark as solution and close the thread
Use this regex for 47094629
Use this regex for ** -2.00 2063.81**
In first one i have others no also which have 8 digits its also highlighting is there any other query
This one is good for extracting
In 2 we have many - sign can Space is common in every extraction please add space
is second one not working for you?
Here is the output with the regex expression
Find the below regex expression
Check the regular expression extraction
Check the below workflow I got the output
Hope it helps!! @Kuldeep_Pandey
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.