7 Replies Latest reply on Nov 23, 2020 4:23 AM by Saurabh Shrivastava

    Convert Excel data into a .txt file having tilda ~ as a separator

    Saurabh Shrivastava Guru

      Hello All,

       

      I am getting data in an Excel spreadsheet(.xlsx format) as below

       

      My requirement is that I need to convert this data into a .txt file having tilda(~) as a separator as below

       

      FEATURE_NAME~IS_AVAILABLE~LOCATION_ROWID~LOC_PKEYSRC_OBJECT~PKEY_SRC_OBJECT

      ABCD~YES~SJCC14~SJCC14|XY~SJCC14|XT|AP|Notes_1

       

      Please suggest a way to achieve this.

        This content has been marked as final.  Show 7 replies