Recent changes to how data is being captured in our website forms has meant that multiple responses are being captured into a single cell with responses separated by the vertical line character glyph. Currently we don't have a solution on how to import the data from the single cell via IOM or even if a regular expression or other tool is available in IOM to handle this. We know we can covert data manually using Text to Columns command. We would prefer not to manually change the files as increases possible errors.
I would welcome comments from the forum if anyone has encountered this challenge before and has come up with a solution.
Very grateful for your help, Alberto