Hi, can anyone help me; I need a function/procedure where I can pass it a table name, column name and delimiter and have the column split into as many new columns as there instances of the delimiter. The number of delimiters can vary.
My table has an ID and some contact name columns and an address column. The address is in one column instead of several and this is separated by commas:
1 Gdc, Plot No. B 1, MIDC, Software Technology Park, Talawade, Tal Haveli
2 Gate No 166 / 167, Pune Nagar Road, Sanaswadi, Shirur
I need this to be split like this:
Col1 Col2 Col3 Col4 Col5 Col6
GDC Plot No. B 1 MIDC Software Technology Park Talawade Tal Haveli
Gate No 166 / 167 Pune Nagar Road Sanaswadi Shirur
Thanks in advance for your help.