How to trim particular Column without using Foreach

Help Something Else
1

Hi All i have to trim particular column in uipath without using for each i tried uipath linq i’m getting an error kindly help me if youhave any query for that

2

Hi @Buvaneshwaran_R

Try this expression

dt1.AsEnumerable().ToList.ForEach(Sub(row) row(“Number”)=row(ColumnName).ToString.Trim)

Regards
Gokul

3

@Gokul001 Thanks for your response i’m getting an error called expression does not produce any value

4

Can you share the screenshot @Buvaneshwaran_R

5

I can’t share the screenshot its in the vdi

6

Hi @Buvaneshwaran_R

Try this expression

Dt.AsEnumerable.Where(Function (x) x("TEAM").ToString.Trim.Any)

Regards
Gokul

1 Like
7

it’s working Gokul Thanks for support

8

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