Regex operation

Help
, ,
1

hey i got this output but i want to split or segregate data according serial no and till description of goods like “1 Fi 1.5 sqmm 100m Frls Green” these much i want only .
Screenshot (10)
thanks
cheers :slight_smile:

1 Like
2

paste that entire text here

3

Hi
If the input is stored in a variable named strinput
—now use this
stroutput = System.Text.RegularExpressions.Match(strinput.ToString,”.*(?=[0-9].-[a-zA-Z].-[0-9].)”).ToString.Trim

Cheers @monikanimbalkar

4

Sl Description of Goods Due on Quantity Rate per Disc. % Amount
No.
1 Fi 1.5sqmm 100m Frls Green 14-Dec-2019 12.000 COL 750.06 COL 9,000.72
2 FI 2.5SQMM 100M FRLS BLACK 14-Dec-2019 12.000 COL 1,230.82 COL 14,769.84
23,770.56

from these i want only

  • "Fi 1.5sqmm 100m Frls Green " “12.000 COL”
  • “FI 2.5SQMM 100M FRLS BLACK” “12.000 COL”

thanks

5

1 Fi 1.5sqmm 100m Frls Green 14-Dec-2019 12.000 COL 750.06 COL 9,000.72 this is coming as a one entire string??
and next one is this
2 FI 2.5SQMM 100M FRLS BLACK 14-Dec-2019 12.000 COL 1,230.82 COL 14,769.84
23,770.56

Right??

6

Yes, but i want to separately like as i said "FI 2.5SQMM 100M FRLS BLACK " “12.000 COL”
for second as well

7

from that one string you need two set of strings like "FI 2.5SQMM 100M FRLS BLACK " and “12.000 COL”

8

Yes
cheers :slight_smile:

9

Fi 1.5sqmm 100m Frls Green 14-Dec-2019 12.000 COL 750.06 COL 9,000.72 from this string is format fixed or 12.000 COL this is fixed

10

this one…

1 Like
11

okay @monikanimbalkar
here you go
1). This one will give you first value (?<=\d{1,3})(.|\n)*(?=\d{2}.[A-Za-z]+.\d{4})
2). This one will give you Second value \d[12].\d{3}

image
image1366×768 137 KB
Main.xaml (7.3 KB)

12

if this what you are looking for and you got it,
mark this as solution and close this thread
cheers @monikanimbalkar

13

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