AnsweredAssumed Answered

repeating fields have upside down question mark characters in csv export

Question asked by MacDevGuy on Nov 22, 2016
Latest reply on Dec 5, 2016 by MacDevGuy

I am trying to convert a repeating field to a portal using the instructions in this document. After exporting a sample of the data when I open the file in BBEdit I see upside down question marks between the fields and at the end of each record.
When I open the file in TextMate I see instead, commas between the repeating fields in most of the fileds, yet in some I see "^K" and others "<GS>" separating the fields, followed by "<GS><GS><GS><GS><GS><GS><GS><GS>""


Why is the display different in BBEdit versus TextMate and why are some of the records separated by CONTROL-K?

Outcomes