RegEx of string

Help Studio
1

Hello,

i want to reg exp of given string:

  1. 310.00/1-KG

  2. 93,000.00

Thanks
Minal Patil

2

Hi @minal.patil
Can you explain your question in details?

3

what is the regulars expression of given strings:

  1. 310.00/1-KG
  2. 93,000.00

I want to regulars expression to find the above strings.

4

HI @minal.patil

Can you tell us the expected output?

How about this expression? If you need to get all the string if so you can try with this one.

System.Text.RegularExpressions.Regex.Match(YourString,"\d.*").Tostring

image

Regards
Gokul

5

not all string?

String: -
Item Material Description Unit Dispatch Date
Order Qty Price per unit Net value Vendor Mat. No

00010 309X185 LOSARTAN POTASSIUM KG 93,000.00 08/03/2020
300.000 310.00/1-KG

To find:------

1st out put is:

  1. 310.00/1-KG

2nd output is:
2. 93,000.00

6

yes i tell expected output?

7

Use this code to extract the second output

Pattern Code: \d{1,3},\d{3}.\d{2}

image

Thanks!!!

8

HI @minal.patil

Can you try like this?

Split(YourInputString," ").Last

Output -> "310.00/1-KG"

Split(YourInputString," ")(split(YourInputString," ").count-4)

Output -> "93,000.00"

image

9

Thanks it is solved

10

i want to using reg exp. because i scrap pdf into TXT format. after that i want to expected output.

11

Hi @minal.patil

To getting 1st output use this pattern : \b\d{3}.\d{2}/1-KG\b$

image
image958×596 13.7 KB

To getting 2nd output use this pattern : \d{1,3},\d{3}.\d{2}

image
image948×598 13.2 KB

Thanks!!!

12

thanks for help
but in 1st string KG value is not fix

13

@minal.patil
Check my last post screenshots. It extracted both value correctly.
Try this : \d{1,3},\d{3}.\d{2} | \b\d{3}.\d{2}/1-KG\b$

image
image955×598 15.8 KB

Thanks!!!

14

value are dynamically change

eg. :

4103.050/2-FH

15

Hi @minal.patil

Try this pattern now: \d{1,3},\d{3}.\d{2} | ([^\s]+)/(.*)

image
image940×585 11.7 KB

Sample Output
image

I hope it will work in your case. Mark it as solution if it works
Thanks!!!

16

image
image936×591 15.7 KB

not solve

17

input string:

Item Material Description Unit Dispatch Date
Order Qty Price per unit Net value Vendor Mat. No

00010 309X185 LOSARTAN POTASSIUM KG 08/03/2020
300.000 310.00/1-KG 93,000.00

00010 309X185 xxxxxxx xyxzyxs KG 08/03/2020
300.000 4103.050/2-FH 93,000.00

i want to output as below:

  1. 310.00/1-KG and 4103.050/2-FH
  2. 93,000.00 and 93,000.00