Multiple Character Delimit Column

[aclawson]

I have a block of invoice data that I need to delimit to extract information. The problem I run into is that in a critical explanation field, there isn't much of a uniform standard among our AR processors. They use basically the same layout: Object [delimiter] Quantity [delimiter] Rate, which would be easy enough if they would all use the same delimiting character, but one will use ³, another |, or another ¦.

Is there a way to delimit the entire colum by multiple special characters such as these?

Delimiting one after the other in a loop causes losses in data. I'd rather not have to delimit cell by cell down a 100,000+ line invoice history if it can be avoided.

Thanks in advance.

[JBeaucaire]

Can you do a search/replace on the data first to convert the uncommon delimiters into the most common delimiter, then split the data by the now-commonly-delimited data?

[aclawson]

That should do it.

It's always the simple solutions I overlook. It helps to have a second set of eyes on the question.

Thanks again, Jerry.