There will be a 1-hour downtime on Saturday, July 2 at 2 pm CEST; 8 am EDT. Services including Activity stream, Subscription, Tag suggestion, User management, and Relay will be unavailable. Blogs and Answers will not be affected.
Hello and congrats with a good start! This is staff I was looking for as well. I just need some more explanation: 1) How to know what HEX code for my separator? like that TAB is 009? 2) What is Escape sign?
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.
This is staff I was looking for as well. I just need some more explanation:
1) How to know what HEX code for my separator? like that TAB is 009?
2) What is Escape sign?
Thank you!!
Vitaliy
How r u ?
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
Thank you for explanation. And sorry, I did not notice the link to Hex table in the first place.
Regards!
Vitaliy
How are you man? Its a good start and keep up ur good work.
Thanks,
Pavan.
i couldn't open the link.
Thanks,
GK