How to extract all strings from an excel cell, which are divided by a semicolon?

excel
activities

#1

How to extract all strings from an excel cell, which are divided by a semicolon? All the strings from the cell should be added to a different Database one by one and the loop should stop when the last string was added. Can anyone help me?

Thanks in advance, Max


#2

Hello @MaxSchmidt,

Hope this could help you, try to use SpltString activity.

  1. Extract Data from an excel cell with Read Cell Activity.
  2. Use SplitString activity to get an array with all the strings.
  3. Loop that array and processing each of its elements.

Here is an example SplitExample.zip (5.0 KB)

Regards,
Susana