Regex needed 21

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
image
image
There are only two things in bold here which is the third one ?
Regards,

1 Like

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 :innocent:

Regards

@Kuldeep_Pandey

Use this regex for 47094629
Use this regex for ** -2.00 2063.81**

@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+ try this

image

Regards,

^\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?

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

Hey!
Can u try with this


Hope it helps

1 Like

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