Hello all. I'm sorry if this has been discussed (i've searched the forums for an hour to no avail)
I have a data column in a SQL db table that has a large varchar string seperated by commas (lets call the column name *raw_data*.
An example is
55 NE HAGY ST, , CAMAS, ZZ, 94407-. , , , ,P , -, .
or
188/8 MVP CCD TR, , VIZ, DD 52201-. EFFECTIVE DATE: 11/21/2007. , , , ,P , -, . EFFECTIVE DATE: 11/21/2007.
Very confusing data.
I need to pull outa single piece if data (say where the P is) always between the 8th and 9th commas. The data and lengths vary from record to record so all I have to go by are the commas.
Any insight would be extremely helpful.
Thanks a lot.
ZZ