Regex needed 21

[Kuldeep_Pandey]

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

[B_H_Akshatha_Pai]

@Kuldeep_Pandey


There are only two things in bold here which is the third one ?
Regards,

[mkankatala (Mahesh Kankatala)]

Hi @Kuldeep_Pandey

You can use the below regular expressions

Hope it helps!!

[Kuldeep_Pandey]

Thanks I will do 3 one by my own

[B_H_Akshatha_Pai]

@Kuldeep_Pandey

4525 14/06/2023 AS PARTS 10/06/2023 308383.39 -262.00 308121.3
PURCHASE

If my solution has helped you kindly mark as solution and close the thread

Regards

[indra]

@Kuldeep_Pandey

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

[rlgandu]

@Kuldeep_Pandey

Str_outPut=System.Text.RegularExpressions.Regex.Match(Input,“Expression”).Value

[Kuldeep_Pandey]

In first one i have others no also which have 8 digits its also highlighting is there any other query

[B_H_Akshatha_Pai]

^\d+ try this

Regards,

[Kuldeep_Pandey]

^\d{8}
This one is good for extracting
In 2 we have many - sign can Space is common in every extraction please add space

[B_H_Akshatha_Pai]

is second one not working for you?

[mkankatala (Mahesh Kankatala)]

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

[tazunnisa.badavide (Taj)]

Hey!
Can u try with this

Hope it helps