To get data before commas and pipe
Posted: Wed Oct 17, 2012 5:53 am
Hi,
I have a quesion as below:
IPfield
Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012
should get a data like this below
OPfield
Nafta|Cafta|bafta
Please note the IPfield data can more with pipes.
for example i can also have data like:
Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012|Cafta,no2,2012|bafta,no2,2012
OPfield should be
Nafta|Cafta|bafta|Cafta|bafta
Could please help to figure out this logic.
Regards
I have a quesion as below:
IPfield
Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012
should get a data like this below
OPfield
Nafta|Cafta|bafta
Please note the IPfield data can more with pipes.
for example i can also have data like:
Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012|Cafta,no2,2012|bafta,no2,2012
OPfield should be
Nafta|Cafta|bafta|Cafta|bafta
Could please help to figure out this logic.
Regards