We are receiving values and want to separate them using a delimiter. We've found that colon isn't suitable, nor is a single pipe. Other single characters like semi colon, comma and exclamation mark isn't suitable because these values already exist in some of the values.
Could double pipe be ok? i've not seen these values present in any existing data but wanted to check in case there was a technical reason to avoid.
Sometimes finding the right delimiter can be challenging, since it relies so much much on what data is being collected.
One trick that I have used in the past is to sanitize the data being collected... like for instance, if the data we're collecting doesn't have to be exactly the same format, I will strip out the character that I need to use as a delimiter from the value...
For instance, let's say I want to use colon as my delimiter, but my values are:
I might convert these to:
This just removes the value totally....
"value:value something:another example with my offending character of " (now I know the only : are my delimiters, but technically I've lost a little data)
or I might get fancy and do something like:
Then use classifications to replace "[colon]" back into the text with the original ":"
"value:value[colon] something:another example with my offending character of [colon]"
(again, ensuring that the only ":" are my delimiters, and then after the data is split out, I put the original values back in to the individual values)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
