Regex operation

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 .


thanks
cheers :slight_smile:

1 Like

paste that entire text here

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

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

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

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

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

Yes
cheers :slight_smile:

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

this one…

1 Like

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}

Main.xaml (7.3 KB)

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

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