How to seperate one csv string in parts using microflow

4
Hi, my database value string contains Group1;Group2;Group3. I want to seperate this string so I can create 3 entities of group. Can anyone help how to model a microflow for this issue? Thanks.
asked
2 answers
4

You can create a microflow that looks something likes, you can click on it for a larger version. When you have any more questions about the flow leave a comment and i'll give a better explanation. But this will hopefully explain enough.

Parse csv microflow

answered
3

If the length of 'group1' is always the same you can use the substring function.

So if the length of 'group1' is always 5 characters you can use substring(group1), 5

But as csv-files are ussualy not built up this way (so with varying 'group length') I think the easiest is to resort to Java and let Java return the separated string values

answered