Use Comma (,) seprated value in config file

Help
, ,
1

Hi,

How can I use comma seprated value, or use multiple values for one key in config file.

For information, my config file is in CSV format.

2

Hello @mohammedamaan

May i know how the other values of the CSV file are delimited? by the same comma? or something else like the tab or space or some other character?

If so, you can use the comma separated value .
Once you read it, you can check whether the cell includes commas…
if commas are available, use Split function to split the values into an array.
Next, use a for each activity to loop through the array so that you can access each value individually within the loop

3

Yes its the same comma.

How will it distinguish between if it has multiple value or if it is description on the key

4

Why not use a different character to separate multi values?

5

Yes we can do the. We can use ( ; ) instead of comma.

1 Like
6

Can you please tell me how will I have to define it in the config file using ( ; )

7

You can leave the other columns with comma separation an the multi values with ( ; ) separation in the config file.

Next, when reading it, you can use the same steps I specified in my previous comment…

3 Likes
8

Thanks. It worked.

1 Like
9

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