Add space at the end of each row


What is the best way to add a space to the end of each row in a string?

e.g. I have a string with data such as:
Company Name 1
Company Name 2

After the 1 and the 2 i want a space to appear.


1 Like

Buddy @jon1302

  1. use a excel application scope to read the exel
  2. use a read range activity to get the data from the excel with output variable out_dt
  3. use a For each row loop to iterate through each row in a datatable out_dt
    use a assign activity with variable like this
    row(“ColumnName_1”) = row(“ColumnName_1”).ToString+" "

this will add a space at the end of each ow value

Hope this would help you buddy


1 Like

Hi @jon1302

You can use Assign activity.
For example: “Company Name 1” + " "

1 Like

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