How to bypass the valid comma separator during the fastload

Tools & Utilities
Enthusiast

Re: How to bypass the valid comma separator during the fastload

Are the explanations provided in the above thread not clear enough ?

Highlighted
Enthusiast

Re: How to bypass the valid comma separator during the fastload

here in the above prob in the column 3 contains more than 20 delemeters in it's data forexample then if i am using delemeter as ',' then it  is taking single column data into 20 columns i want load this data as single column as it is not in different columns

  i.e  source is 3 columns and my target also should be 3 columns only but it is not loding like rthis can any one help me please

Enthusiast

Re: How to bypass the valid comma separator during the fastload

column 3

ram,yaragala,....,....,    ,    ,       

nag,gaddam,......,.........,.......,     

mahesh,giddaluru,.......,........,

The above data is belongs to one column so i need to load this data  into single column

Not applicable

Re: How to bypass the valid comma separator during the fastload

Hey ratchetandclank, I was unable to find documentation about fastload & quoted vartext records.

Would you have any pointers to documentation or examples?

It would be great to have a character escape mechanism in fastload (e.g. Field1:abc,Field2:a\,b,Field3:def).

Thanks,

- lenny