Inserting String from CSV to mongoDB: add backslashes

One Star

Inserting String from CSV to mongoDB: add backslashes

Hi, I've developed an ETL job to import data from various CSVs files. So, there's some conversions of data (longs, ints, and per default Strings values).
My problem is, when I saw the data string inserted, have this look:
"prueba" : "\"mate4b\""

And I'm waiting something like:
"prueba" : "mate4b"

There's some config to apply this form?
Thanks in advance guys.
Four Stars

Re: Inserting String from CSV to mongoDB: add backslashes

Have you explored the CSV options on the "Advanced setting" tab of the tFileInputDelimited component, where you can specify escape characters and how to wrap text values?
Four Stars

Re: Inserting String from CSV to mongoDB: add backslashes

Typically, the inputdelimited component will read fields from a file as the type you configured in your schema - without the need for explicit conversion. However, you want to do exception handling to make sure you don't try to convert a value into a type that is not allowed (for example, a field contains "1.00"; if you read this in an integer, you'd have an exception; however if you read it in a double, it would be fine.).
One Star

Re: Inserting String from CSV to mongoDB: add backslashes

You can try using regular expression.