Thank you!! Vitaliy
Here are the answers,1. At the end of the blog there is a link, check there for the Hexa Decimal Values. http://www.lookuptables.com
2. Escape Sign, Take the same Data with different delimiter like - for this u can see 2D as the HEX value. Enter this 002D for the Data Seperator and for the Escape Sing u maintain ".
Now this is how our flat file looks,CUST_NO-CUST_NAME-C_CRE_ON-C_CITY-C_COUNTRYCUS001-ROYAL PVT LTD.-20061001-CHENNAI-INDIACUS002-MARS TUF CORP.-20061001-CHENNAI-INDIACUS003-BAKING COMP.-20061001-MUMBAI-INDIACUS004-TRENDS DESIGNS-20061001-LUCKNOW-INDIACUS005-CORAL-CORP.-20061001-CHENNAI-INDIA
here carefully see the last record. There is a - inbetween CORAL-CORP
Remember, we maintained - as the Data Seperator. This will be an error if we load the data as it is. What we have to do is enclose the whole value within the "Escape Sign" i.e. open and close that value with the Escape Sign like this,
Now the - inbetween CORAL-CORP. will not be considered as a data seperator.
Best Regards....Sankar Kumar+91 98403 47141
Thank you for explanation. And sorry, I did not notice the link to Hex table in the first place.
How are you man? Its a good start and keep up ur good work.
i couldn't open the link.
Enter the destination URL
Or link to existing content