Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (5.3k points)

I have three columns (First Name, Last Name and Phone Number) in my collection that I got from excel using "copy as collection" functionality of Excel VBO.

Please note that there is extra space at the end of First name and Phone number. I want to trim these spaces. Please suggest how to do that. Please also note that I have not defined the column names in my collection. I am directly copying it from excel so that if any changes done in excel then it reflects in the collection dynamically

1 Answer

0 votes
by (9.5k points)

You can use object: utility collection manipulation.

You can use the action of trim collection or you can use the action of remove dot from header and change “.”o “ “ in the code.

Here is how:

For Each Column As DataColumn In Input_Collection.Columns Column.ColumnName=Microsoft.Visualbasic.Replace(Column.ColumnName," ","") Next Output_Collection = Input_Collection

Related questions

Browse Categories