Linq query to manipulate a string

[Shilpa_Mohanty]

I have to eliminate .x from any string.
Input - 120.asf.x
12.kiytr.uf90.x
jgui.22980.gtd.x

Required output
120.asf
12.kiytr.uf90
jgui.22980.gtd

Can anyone please help me with a linq query as I have 74k data in excel and using foor loop is very time consuming

[hasib08 (Motiwala Hasib)]

Refer this post

Using LINQ to replace specific value in DataTable without For-Each

Hi @u2018dem0528 You can try this in invoke code with dt1 as In/Out argument dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“PhoneNo”)= row(“PhoneNo”).ToString.Replace(“-”,“”))

[Shilpa_Mohanty]

Sorry @hasib08 , I need linq query as we are not allowed to use invoke code activity

[hasib08 (Motiwala Hasib)]

Refer this post

How to replace a value in datatable in Uipath without using for each row

Hi Welcome back to uipath community There are actually two ways of doing that —first is convert the datatable to a string with the help of OUTPUT DATATABLE ACTIVITY and pass the datatable as input and get the output variable of type string named str_output —now use a normal assign activity like this str_output = str_output.ToString.Replace(“your old value”,” your new value”) Now use GENERATE DATATABLE ACTIVITY and mention the str_output variable as input And get the output with a variabl…

[Shilpa_Mohanty]

@hasib08

Tried with dt = dt.AsEnumerable().Where(Function(a) a.Field(of string)(“yourcolumnname”).ToString.Replace(“your old value”,” your new value”).ToString).CopyToDatatable()

but here my input column and output column is different

[Yoichi]

Hi,

Can you try the following expression, for example?

dt = dt.AsEnumerable().Select(Function(r) dt.Clone.LoadDataRow({r("Column1").ToString.Replace(".x",""),r("Column2")},False)).CopyToDataTable()

Sequence1.xaml (7.0 KB)

Note : We need to modify arguments of LoadDataRow for actual datatable.

Regards,

[Pranav_Nikam1 (Pranav Nikam)]

@Yoichi

dt = dt.AsEnumerable().Select(Function(r) dt.Clone.LoadDataRow({r("Column1").ToString.Replace(".x",""),r("Column2")},False)).CopyToDataTable()

Hello @Shilpa_Mohanty , I am getting the below error:

[Gangadhar_Athili]

Wrong Query it is…

kidnly Post New Topic

[postwick (Paul)]

@Shilpa_Mohanty

74k data in excel and using foor loop is very time consuming

LINQ isn’t faster than For Each. LINQ still loops, it’s just hidden from you. It’s impossible for data in a table to be updated without looping.