Linq Get String after :

Help Something Else
5

Hi @arina,

What about this workflow

Input
image

Output
image

Workflow

image
image1165×624 24.8 KB

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