We need to combine 2 pieces of data in one field. The data will not be regular expressions. Subsequently we will need to identify each piece of data within the field. We cannot use space , comma , ,underscore _ , hyphen - , backslash\ and forwardslash /as separators.
If we were to use the tilde ~ symbol would this have any implications?
We would have data in the table like this: