Hi @jarviscampbell , I’m not sure you understood what I was trying to do if you said that you hoped I meant bring back to string “before” the split. Before the split, the values in your column target are already strings. It’s only after the split that they do not seem to be anymore.
In any case, I got curious to see what my manipulation gave, and it looks like the split itself gives you the values in Double:
You can see the [D] in the column names that indicates a type Double. The first column stays as String ([S]) because there is the string “any” in it (came with your file).
When I apply the solution I suggested, that’s when it actually gives the same results as what you originally had:
I’m not sure how you got your results, but it would have been helpful to show all these details (that the columns were already of String type, etc).
I always say this “help us help you. The more details/info you give, the more precise the solution will be”.
Nonetheless, the idea is still good, and since it looks like you really wanted the suggestion with the String Manipulation to work, I’ll just make it work with a little hack. In order to keep the columns as String, we just need to make sure that the content being splitted will be string.
To do this, I’ll just add a dummy character within each content, for example, I’ll add the “#” sign.
join("#", replace($target$, ";", ";#"), "#")
After that, you just do your Cell Splitter as you did:
At this point, the cell will be splitted into String columns, with the dummy value added:
Now we can use the solution with the String Manipulation to remove the dummy value, and to keep the columns as String:
string(replace($$CURRENTCOLUMN$$, "#", ""))
And there’s your result:
You basically just need to add these 2 nodes: