Hello,

I hope someone can help me.

I have a text source file, let says with this structure separated with pipes (|):

ID|COLOR|MODEL|VEHICLE

And I need to save the data to a table, but some times the data comes with some extra pipes and this causes the data to move one or several places, for example:

Code:
1|RED|2014|VW

2||RED|2013|GM

3|BLUE||2017||||GM

4|GOLD||2016|||GM|

5|GOLD|   |2016| ||GM|
Is there a way to remove those extra pipes to accomodate the data?

Any help would be appreciated!

Thanks!