Assure DQ

 View Only

  • 1.  How to remove double quotes from a text field

    Posted 12-19-2019 08:22

    I am trying to read in a text file in Infogix Assure 9.2 and was wondering if there was away to remove double quotes within a text file?

    The following is an input file

    {"fund_imported":1,333,767,"total_amount":1,669,218.79}



  • 2.  RE: How to remove double quotes from a text field

    Posted 12-19-2019 09:46

    Hi Adam,

    Thank you for your question. 

    What layout type are you using? If your entire input source is formatted in JSON, then you should use the JSON layout, which includes and article download and instructions linked below. With the JSON layout, the quotes in your field names will be captured without the quotes.

    https://support.infogix.com/hc/en-us/articles/360019680513-JSON-Plugin-Installation

    Please let us know if you have additional questions.