AnsweredAssumed Answered

Exporting Issues

Question asked by Shoreline on Feb 1, 2016
Latest reply on Feb 4, 2016 by beverly

Hi,

 

I have to export data to be imported into another system. The data needs to be in .txt format.

 

The data needs to look as follows.

 

"LIT009FTP","54gfs655","991496","F","1","1"

"1086","2016/02/01"

"1002","228 Photography","228 Photography","1","19044200","1089875185","65000","65000","","","0","0","0","0","0","19314","","",""

"1001","25 Weddings","25 Weddings","1","200912","62508587667","25000","25000","","","0","0","0","0","0","19315","","",""

"1003","Aartsappel","Tanya Buys","2","632005","9264792488","30000","30000","","","0","0","0","0","0","19316","","",""

 

I'm currently exporting as as .tab and on a windows pc opening it with notepad and saving it as .txt

When the same process is done on a Mac it changes the data to the following:

 

"""LIT009FTP"",""54gfs655"",""991496"",""F"",""1"",""1"""

"""1085"",""2016/02/01"""

"""1002"",""228 Photography"",""228 Photography"",""1"",""19044200"",""1089875185"",""65000"",""65000"","""","""",""0"",""0"",""0"",""0"",""0"",""19041"","""","""","""""

"""1001"",""25 Weddings"",""25 Weddings"",""1"",""200912"",""62508587667"",""25000"",""25000"","""","""",""0"",""0"",""0"",""0"",""0"",""19042"","""","""","""""

"""1003"",""Aartsappel"",""Tanya Buys"",""2"",""632005"",""9264792488"",""30000"",""30000"","""","""",""0"",""0"",""0"",""0"",""0"",""19043"","""","""","""""

 

What do i need to do for it to stay same as first set of data? I even tried removing the "" quotation marks but then it enters then in the wrong places.

 

Can someone please assist.

Outcomes