I am reading a text file into a temp table and it's just 1 long line separated by commas. I would like to parse this string into separate fields. How can I do that with a function or sql script?
I may have to do multiple different parse and put into a temp table since some line have more fields then others. If I can parse the above regardless of how many commas into a define table, I should be able to do the rest. Just having issue getting it to parse.