This content has been marked as final. Show 2 replies
I have a string column in a table with ; as delimiter but number of parts are not fixed it can be 1 or 5 or 100.
Any idea how can I split the string and create separate records from it at load time.
LongString, // LongString have values like "ABC;DEF;HIJ;KLM" OR "XYZ;OPR;LMJ" OR "PPP;SSS"