How to enter row items in a field with ";"?

We have an excel with customer ID’s. We want to enter all these data in a single field with “;”. Could you please help with that? (ex. Customer ID1; Customer ID2; Customer ID3; …)


1 Like
  1. Read the data table and loop through the data table
  2. Initialize a string variable assume stringValue
  3. Get the row value using row(“customer”).tostring
  4. Append the each value to the string variable in the step 2 as stringValue = stringValue + row(“customer”).tostring + “;”
  5. Write the stringValue to the required @aysyavuz

here you go a xaml
hope its resolved
kindly try this and let know for any queries or clarification (15.1 KB)

Cheers @aysyavuz

It works with your code. Thank you

1 Like

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