Easy to Create, Easy to Change - Easy to use!


Importing data with quotation marks.


Started by Bolt-on-Trailers
Search
You will need to Sign In to be able to add or comment on the forum!

Importing data with quotation marks.

Hi all,
When I import data that has quotation marks in the text (see example below) extra quotations marks get added to the data. Is there something I can do to prevent this? If it helps to know it is tab delimited data that I am importing.

EXAMPLE
Text.txt data (before import) 1/4"-20 x 5/8"
DataEase data (after import) "1/4""-20 x 5/8""

Written by Bolt-on-Trailers 05/02/18 at 22:48:29 Dataease [{8}]FIVE

Re:Importing data with quotation marks.

I think the problem is that the code is built to handle quote delimited text without there being an option to turn this off. 

A workaround is to search and replace the quote mark for a character that does not appear in your data, and then replace that character in the data when you get it back into DataEase. 

Of course, which char to use will depend on your data, just because that char was not in your data yesterday does not mean it won't show up today. 

As your data is tab separated, you might be able to simply copy and paste it into your table/form, depending on how much data there is. 

All these options are manual, though it might be possible to automate using other tools.

Written by Adrian Jones 07/02/18 at 15:42:04 Dataease [{8}]FIVE

Re:Importing data with quotation marks.

We just tested the scenario where the data attached and it worked fine.

his is a tab separated file with " (copied from the data you wrote in).




We think there is some snags in the export files that is not visible but might be causing confusion when you try to import. Could you upload the file so we can take a look in the hexeditor/debugger?

Written by DataEase 08/02/18 at 21:53:51 Dataease [{8}]FIVE