Hi,
The data in the sting is mixed with Alpha numeric & numeric and every field is separated by comma. (,). but all the alphanumeric fields has a additional quotes in it.
But i need to remove the additioanl quotes from Alphanumeric fields in order to perform unstring by comma to use the data.
Example 1:
'"600","CY",8,"3787660","000043877",14099.83,1166.96,"USD"'.
But I need the above record as shown below:
EXAMPLE2:
'600,CY,8,3787660,000043877,14099.83,1166.96,USD'.
So that i can unstring the data shown in exapmle 2 using just ','.
Note:
I managed to remove the quotes using ICETOOL Replace command but it takes 4 step procedure to remove .
But is there any way by using single sort/icetool step to achive as shown above to remove the additional quotes in alphanumeric fields?
First step S1: I replace " "," " to ",".
Second step S2: I replace " ", " to ",".
Third step S3: I replace " ," " to ",".
Fourth step S4: i replace " " " to " ".