I am trying to split a string within a column field using a workflow in SPD 2007. The string may or may not have multiple items in it. As an example, I have a string that is as follows: "Houston; San Diego; Los Angeles; Atlanta".
They are all in the same column. and always will have a semi colon as a delimiter. The number of items in each string will vary any where from 1 to 10 items. I want to split the string up into multiple columns (or rows) and end with the following result:
Column 1: Houston
Column 2: San Diego
Column 3: Los Angeles
Column 4: Atlanta
I am trying to do this without any custom code since I am not a developer, so I am looking for a solution that is based on a workflow, or a calculation. If code is the only way, then so be it. I will do what I have to do. Any help would be great...
