tommarshallandrews
asked on
splitting a string
i am trying to convert a field containing a string into 3 fields.
the string is of the format
alphanumeric decimal [comma] decimal
eg.
Moyo Island -8.259857,117.573064
i want it split in 3 eg.
Moyo Island | -8.259857 | 117.573064
the string is of the format
alphanumeric decimal [comma] decimal
eg.
Moyo Island -8.259857,117.573064
i want it split in 3 eg.
Moyo Island | -8.259857 | 117.573064
Look at the section
3. Parse the list into a set
that's awkward, your list is not delimited - you could really have done with a delimiting character between the place name and the co-ordinates. The delimiter mustn't appear in the place name, in this case you have a space which can also appear in the place name.
A function reading back through the string could be written to strip out the two numbers.
A function reading back through the string could be written to strip out the two numbers.
ASKER
Thanks guys.
My idea was to try and strip all the numbers & commas out to get the place name then strip the characters to get a comma separated string and try and pot that into 2 columns.
Would that make sense? If so any idea how??
Thanks
My idea was to try and strip all the numbers & commas out to get the place name then strip the characters to get a comma separated string and try and pot that into 2 columns.
Would that make sense? If so any idea how??
Thanks
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Refer to this article with example from AngelIII
https://www.experts-exchange.com/Database/Miscellaneous/A_1536-delimited-list-as-parameter-what-are-the-options.html