Data has multiple pipe

[#1]

I have txt file with Pipe separation. The issue is some times I have multiple pipe (could be data import issue) creating data spillover. Is there any want to solve this in the load script?

[robert_mika]

Could you post sample of your data and what you need to do with them