Hello all:
This is more of curiosity but I have data in my events table currently trapped in a nvarchar field. I am wondering if I can build a table and do execute a select into with a python UDF pulling data from the existing fields plus the values of my nvarchar field.
My string data has the following format -
"key1=value, key2=val, key3=value"...
I want to break out the data first by splitting on the , and then the = Keys would be the columns in the table.
I can do this with a python script and pymonetdb but a UDF would be faster.
Adam Doherty Process Control Systems Administrator Kearl Technical, Imperial 505 Quarry Park Blvd SE W3B.224 Calgary, AB T2C 5N1 adam.doherty@esso.camailto:adam.doherty@esso.ca P 587.476.4640tel:+15874764640 M 403.869.1636tel:+14038691636 imperialoil.cahttp://www.imperialoil.ca/Canada-English/default.aspx | Twitterhttp://www.twitter.com/imperialoil | YouTubehttp://www.youtube.com/imperialoil