DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Text Data Plugin Wizard - Ignore Delimeters Inside Double Quotes

Solved!
Go to solution

I'm trying to use the Text Data Plugin Wizard to load data from a CSV file using a comma delimiter.  Wondering how I can get the delimiters inside double quotes to be ignored.

0 Kudos
Message 1 of 4
(142 Views)

Can you share an example file with a description which delimiter is to ignore?

DIAdem experience since 1996

Turn-key applications - Remote and on-site trainings - On-the-job training

| müller+krahmer GmbH | Koenitzer Straße 14, 07338 Kaulsdorf / Germany |
| Phone: +49 36733 / 2328 - 6 | Mobile: +49 160 / 287 7294 |
| Email: mueller@mueller-krahmer.de | Web: www.mueller-krahmer.de |
0 Kudos
Message 2 of 4
(120 Views)

Would like to ignore the comma delimiter inside the double quotes.

0 Kudos
Message 3 of 4
(114 Views)
Solution
Accepted by topic author danbo_16

mllerkrahmer_1-1731325173232.png

 

I have only German versions of DIAdem here so I can only show a German language screenshot. If you set the parameter marked in orange (don't how it is called in the English version but literal translation would be text recognition character) to double quotes the entire section between the double quotes will be imported as one single text channel.

DIAdem experience since 1996

Turn-key applications - Remote and on-site trainings - On-the-job training

| müller+krahmer GmbH | Koenitzer Straße 14, 07338 Kaulsdorf / Germany |
| Phone: +49 36733 / 2328 - 6 | Mobile: +49 160 / 287 7294 |
| Email: mueller@mueller-krahmer.de | Web: www.mueller-krahmer.de |
0 Kudos
Message 4 of 4
(95 Views)