Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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.