Remove space from lastrow in a datatble

[Vasavi (Vasavi Gatiganti)]

Anyone could you please help on this

We are having a CSV and last two rows are having spaces.
when I read csv it is storing in a datatable ,
Last two rows of a datatable are also getting with spaces.
Anyone could help in removing the rows that contains space in the datatable

[Pablito (Pawel Wozniak)]

Hello @Vasavi,
Welcome to the Community!
If you are keeping data in DataTable you can refer to particular indexes in the rows and use some text operations on them like in this example:

Remove spaces infront while populating data from datasheet

Please help me here. I am extracting data from data table populating those data in web application in one text field. Good thing is - I can able to populate the same data Bad thing is - It is writing the text with space at the beginning of the word. Please help me how to remove that space in front of the word. Responses are much appreciated. [image] [image]

How to remove trailing space in an excel column

Hello everyone, I have a data table consist of 4k rows of data and I need to trim a trailing space in a particular column called JO No. [image] [image] as you can see above there is a spacing behind the value. [image] [image] This is what I have come up with to the trim the spaces in the column but it does not seem work properly. Could anybody point out what I should do to fix this workflow? YPD Variance map testing.zip (149.6 KB) here is my workflow Thank you, HarizD