How do I parse a varchar field based on a delimiter ?

[JFK40]

I need some help on the following please.

I am trying to parse or 'break up' a varchar field based on a delimter in SQL. I have tried using substr and postr but this gets very messy as the number of parts increases. There must be am easier way to do this, but I can't think of it.

Any suggestions would be gratefully appreciated !

 

[blom0344]

If this is a one time exercise; you may skip the SQL approach and simply export the table to a file. Then use the import wizard of either Excel and Access to split up the records using the seperation character, do a column count, create a table accordingly and upload the data again.
Looks very hard to accomplish with just SQL......

T. Blom
Information analyst
tbl@shimano-eu.com

 

[JFK40]

Sorry but this is not a one off exercise. But it could be done via SQL or in a stored procedure.

Any further ideas ?

 

[MarcLodge]

Could you possibly do something with the CASE statement and SUBSTR? This would of course depend upon the size of the field being parsed.
Marc