Remove spaces from column value

Learn Academy Feedback
1

im filtering datatable but in one column’s value has spaces

i used trim, it didnot help

2

row(“ColumnName”).ToString.Trim

It will work only for space located at the start or end

3

that column value is fixed
so i have used Filterdatatable in which
“Subject”= in_Subject.Trim

in_Subject has value “English”

The value English in Excel contains spaces like this "English " , so BOt doesnt give accurate results

4

try using

In_Subject.ToString.Trim

5

no , it didnt help

6

@Ananya1 Can you maybe show screenshots of how you are performing the operation ? You might need to Iterate the Datatable using a For Each Row and make a Trim Operation for each of the Column’s Values

1 Like
7

Hi Ananya
please give me excel file and show me where you want remove spaces

8

Hi @Ananya1

Even the input has no spaces ie in_Subject has no spaces but when u compare with excel columns who cell values have whitespacing and end or start of words. Then the filter datatable activitiy will return empty values

So as told by @supermanPunch
u need to make a sequence which iterate through datatable and using an if condition with condition as row(“ColumnName”).ToString.Equals(in_Subject)
And then filter it Accordingly

Regards

Nived N

Happy Automation :relaxed::relaxed::relaxed: