Linq Get String after :

[arina]

How do i achieve this by using Linq? The rows are unlimited in real situation so that’s why I’m resorting to Linq.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@arina
Inside for each row in data table
assign

System.Text.RegularExpressions.Regex.Match(currentrow(0).tostring,"([a-zA-Z]+)(\d+)").Groups(2).Value

[Yoichi]

Hi,

Can you try the following sample?

dt.AsEnumerable.ToList.ForEach(
Sub(r)
    r("Description")=System.Text.RegularExpressions.Regex.Match(r("Description").ToString,"(?<=:\s+).*$").Value
End Sub
)

Sample20221205-3.zip (8.7 KB)

Regards,

[Gokul001 (Gokul Balaji)]

Hi @Yoichi

1. Use Read Range activity → Store it as DtRead

2. Use For each row in data table activity

Note : In the LINQ it will also loop through Line by Line there is no difference

Inside the Loop

3. Use Assign activity

CurrentRow("Description") = 
System.Text.RegularExpressions.Regex.Match(CurrentRow("Description").ToString,"\d*$").Tostring

Outside the Loop

4. Use Write Range activity and Pass the DtRead as output

Regards
Gokul

[RajKumar_DC (RajKumar Durai)]

Hi @arina,

What about this workflow

Input

Output

Workflow

Xaml
05.xaml (7.1 KB)

Code

(From row In dt.AsEnumerable
Let output = If(row(“Input”).ToString.Split(CChar(“:”)).count>1,row(“Input”).ToString.Split(CChar(“:”))(1).Trim,row(“Input”).ToString)
Select dt.Clone.Rows.Add(row(“Input”).ToString,output)).copytodatatable

Best,
Raj