There is maximum number of tokens in the string - n
I need to split each string and put every token in its respective column for further manipulation:
Now my requirment is only for 7 tokens but in future i will use it dynamically.and iam going to use this data in multiple places so i want it as a function.or tell me any other better way.
Kindly help me pls
As a break from suggesting the @JeffModen solution, here is one from Brad Schultz - http://bradsruminations.blogspot.com/2009/10/un-making-list-or-shredding-of-evidence.html
You can take column values into a string and take a string and split it into columns/rows.I havent tested it but if you are working with lots of records you may want to test this and the Tally Table method to ensure you pick the most performant