topic Re: Inserting String from CSV to mongoDB: add backslashes in Talend Studio

Inserting String from CSV to mongoDB: add backslashes

Anonymous — Sat, 16 Nov 2024 11:44:07 GMT

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

willm1 — Mon, 03 Mar 2014 14:56:14 GMT

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?

Re: Inserting String from CSV to mongoDB: add backslashes

willm1 — Mon, 03 Mar 2014 14:59:32 GMT

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

Re: Inserting String from CSV to mongoDB: add backslashes

_AnonymousUser — Wed, 07 Jan 2015 09:37:13 GMT

You can try using regular expression.