Split Column in reverse order

[jfbratt]

I want to split my "Geographic.Location" column into several columns by the ";" separator. While most of my records have a town;county;state;country;continent structure, some of them don't include a town or city. When I split the column, the split values for those records are placed in differing columns from the records that include a town.

Essentially, I would like to split into column but place the values left to right instead of right to left. Does this make sense? If it does, is there a way to acheive this?

[ostephens]

You could try doing a transformation on the cell first of

value.split(“;”).reverse().join(“;”)

And then do the split column as usual