Loading Text Files(.TXT) into BW with HEX option

Thanks !

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_COUNTRY
CUS001-ROYAL PVT LTD.-20061001-CHENNAI-INDIA
CUS002-MARS TUF CORP.-20061001-CHENNAI-INDIA
CUS003-BAKING COMP.-20061001-MUMBAI-INDIA
CUS004-TRENDS DESIGNS-20061001-LUCKNOW-INDIA
CUS005-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,

CUS005-"CORAL-CORP."-20061001-CHENNAI-INDIA

Now the - inbetween CORAL-CORP. will not be considered as a data seperator.

Clear !?

Best Regards....
Sankar Kumar
+91 98403 47141