0

Export Data in UTF-8 With Inverted Commas Around Text

Good evening all, I am wanting to merge two geographical data sets, both which are in UTF-8 format and both which can be split by record type and created as relational databases (Table_1, Table_2 and Table_3).

There is no BOM attached to the files, nor is one wanted.

Table_1 has a one to many relationship with Table_2

 

Table_1 has a 1 to many relationship with Table_3.

 

All text, prior to importing, has inverted commas around them.

 

I have created the tables (still need to work on the error checking), created the relationships and have imported test data in to each of the tables. The imports work fine.

 

I have to play around with various fields in the data, setting up auto numbering by grouped data (e.g. Table 1 must auto-number, Table 2 must auto-number for anything which has the same secondary key, and, table 3 must auto-number anything which has the same secondary key). These are issues for me to play with later.

 

My problem currently is, when I export test data, as a CSV file, the inverted commas are not around the text.  Is there any way of getting Ninox to put the inverted commas around the text?

Reply

null

Content aside

  • 3 yrs agoLast active
  • 546Views