comma delimeted files

[kkreddy]

hi guru's
i have a senerio where in the ", " delimeted seq file ,inside the column contains "," like
001,ravi,kumar,98
002,ramkumar,34

could u please let me know is there any whay to solve this
Thanks in advance

KKReddy

[loveojha2]

Read a whole line as a single column, you can achieve this with having 000 as the quote character and 010 as the delimiter. Now process this single column according to the requirement.

hi guru's
i have a senerio where in the ", " delimeted seq file ,inside the column contains "," like
001,ravi,kumar,98
002,ramkumar,34

could u please let me know is there any whay to solve this
Thanks in advance

KKReddy

[loveojha2]

Its not easy even with a single column, since you are not sure of the field boundaries.

[kcshankar]

Hi,

Is your source file have similar pattern,ie delimiter variation is only in the second/string field.

Code: Select all

001,ravi,kumar,98 
002,ramkumar,34 

Assuming u want output to be like this below,
001,ravikumar,98
002,ramkumar,34

Define ur source file with 000 delimiter -single Column.

Declare StageVariable to hold the count of ","
DCount (string, delimiter)


For 1st record
Use Field ("Source"string, ",", 1)

For Last Record
Use Field ("Source"string, ",", (StageVariable))


For 2nd record
Trim((Iconv("Source", "MC/N")),",""A")


Regards
kcs