From Friday, January 17th 11 PM CDT (January 18th 5 AM UTC) through Saturday, January 18th 11:30 AM CDT (January 18th 5:30 PM UTC), ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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
(355 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
(333 Views)

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

0 Kudos
Message 3 of 4
(327 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
(306 Views)