Hi Team
I want some help in regex My input is
INV REF POST DATE DESC INV DATE GROSS AMOUNT TDS Amount
(INR)
47094629 16/06/2023 AS PARTS 10/06/2023 2065.81 -2.00 2063.81
PURCHASE
47868528 14/06/2023 AS PARTS 10/06/2023 3626.35 -3.00 3623.35
PURCHASE
47264525 14/06/2023 AS PARTS 10/06/2023 308383.39 -262.00 308121.3
PURCHASE 9
I want output from all three 1 element 47094629 2.00 2063.81 I have mentioned all three in a bold
@Kuldeep_Pandey
There are only two things in bold here which is the third one ?
Regards,
1 Like
mkankatala
(Mahesh Kankatala)
August 10, 2023, 11:21am
3
Hi @Kuldeep_Pandey
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
Regards
indra
(Indra)
August 10, 2023, 11:23am
6
@Kuldeep_Pandey
Use this regex for 47094629
Use this regex for ** -2.00 2063.81 **
rlgandu
(Rajyalakshmi Gandu)
August 10, 2023, 11:23am
7
@Kuldeep_Pandey
Str_outPut=System.Text.RegularExpressions.Regex.Match(Input,“Expression”).Value
In first one i have others no also which have 8 digits its also highlighting is there any other query
^\d{8}
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?
mkankatala
(Mahesh Kankatala)
August 10, 2023, 11:53am
12
Here is the output with the regex expression
Find the below regex expression
^(\d+)|(?<=\d+\/\d+\/\d+\s+\d+\.\d+\s+).*
Check the regular expression extraction
Check the below workflow I got the output
Hope it helps!! @Kuldeep_Pandey
system
(system)
Closed
August 13, 2023, 12:03pm
14
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.