Split the data current data

Help Activities
, , ,
1

Exist text : 00:00:00 15787 Online

What I want : 15787

image

2

HI @Manju_Reddy_Kanughula

Checkout this expression and use this inside the for each row in datatable

System.Text.RegularExpressions.Regex.Match(CurrentRow(1).Tostring.Trim."(?<=\d{2}:\d{2}:\d{2})\d+").Tostring

Regards
Sudharsan

3

Hi @Manju_Reddy_Kanughula

How about this Regex expression?

System.Text.RegularExpressions.Regex.Match(CurrentRow(1).Tostring.Trim."\d+(?=Online|Offline)").Tostring

image

Regards
Gokul

4

Another way to achieve using the Regex expressions @Manju_Reddy_Kanughula

System.Text.RegularExpressions.Regex.Match(CurrentRow(1).Tostring.Trim."(?<=\d{2}:\d{2}:\d{2}\s)\d+").Tostring

image

Regards
Gokul

5

Hey

another aproach if you want the same pattern in all the rows,

dtInput.AsEnumerable.Select(Function(x) Regex.Match(x("Column").ToString, "\d+(?=Online|Offline)")).Where(Function(a) a.Success).Select(Function(k) k.Value).ToList()

image
image1040×532 18.2 KB

Regards

6

I have negative values, i need those values too.

“00:00:00 -72623 Offline”

7

How about this expression? @Manju_Reddy_Kanughula

System.Text.RegularExpressions.Regex.Match(CurrentRow(1).Tostring.Trim."\d+(?=Online|Offline)|-\d+(?=Online|Offline)").Tostring

image

System.Text.RegularExpressions.Regex.Match(CurrentRow(1).Tostring.Trim."(?<=\d{2}:\d{2}:\d{2}\s)\d+|(?<=\d{2}:\d{2}:\d{2}\s)-\d+").Tostring

image

Regards
Gokul

8

You can try this @Manju_Reddy_Kanughula

System.Text.RegularExpressions.Regex.Match(CurrentRow(1).Tostring.Trim."(?<=\d{2}:\d{2}:\d{2}).*(?=\sOffline|\sOnline)|(?<=\d{2}:\d{2}:\d{2}\s).*(?=\sOffline|\sOnline)").Tostring.Trim

image
image966×399 25.5 KB

Regards
Sudharsan

9

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