Regex needed 21

Help Robot
,
1

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

2

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

3

Hi @Kuldeep_Pandey

You can use the below regular expressions

image
image1232×479 34.1 KB

Hope it helps!!

4

Thanks I will do 3 one by my own

5

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

Regards

6

@Kuldeep_Pandey

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

7

@Kuldeep_Pandey

image
image909×344 26 KB

image
image877×340 26.6 KB

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

8

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

9

^\d+ try this

image

Regards,

10

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

11

is second one not working for you?

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

image
image875×462 27.1 KB

Check the below workflow I got the output

image
image709×487 57 KB

Hope it helps!! @Kuldeep_Pandey

13

Hey!
Can u try with this

image
image698×271 23.8 KB

Hope it helps