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.