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.
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.).