What type of file is being used? Is it a txt file? Have you defined the delimiter as a comma?
The file I am usinig is a .csv file. The file contains the data as follows
1 a a,b,c
2 b c,d,e
3 c f
So, generally the file is tab delimeted, so I used the delimeter as tab.
So after tab delimeting, for one column the data will be as
So using the above data I need to create a filed(maybe calculated field) which contains the data as