This content has been marked as final.
Show 2 replies
-
1. Re: Comma seperated values inside tab seperated values.
Tracy RodgersAug 22, 2012 10:22 AM (in response to Rohith Reddy)
Hi Maddy,
What type of file is being used? Is it a txt file? Have you defined the delimiter as a comma?
-Tracy
-
2. Re: Comma seperated values inside tab seperated values.
Rohith Reddy Sep 5, 2012 6:53 AM (in response to Tracy Rodgers)Hi Tracy,
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
a,b,c
c,d,e
f
So using the above data I need to create a filed(maybe calculated field) which contains the data as
a
b
c
d
e
f