Skip to Content

5 Comments

You must be Logged on to comment or reply to a post.

  1. Witalij Rudnicki
    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?

    Thank you!!
      Vitaliy

    (0) 
    1. Sankar Kumar Post author
      Hello 🙂 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

      (0) 

Leave a Reply