AnsweredAssumed Answered

How to make a correct TXT file for Microsoft

Question asked by microbatteryshop on Sep 26, 2012
Latest reply on Sep 27, 2012 by microbatteryshop

Title

How to make a correct TXT file for Microsoft

Post

     For four days I'm trying to make a file export from FileMaker Pro to a TXT or CSV file so I can import it into actinic.

     First I try to put all my separate words for my table into a separate fields.

     And I export it as a TXT or CSV separated with a comma.

     It looks like this below:

      

     ------------
"Header:PriceSchedule","Schedule Name","Base Schedule","Calculation Method","Calculation Factor","","","","","",""
"Header:Price","Customer Group","Price","Minimum","","","","","","",""
"Header:Product","Product Reference","Short description","Full description","Image filename","Price","Tax Treatment","Cost Price","Shipping data","Stock in hand","Stock checks enabled"
     ------------
     However in this case I have empty fields and  Microsoft does not recognize the new line! And it put everting in one line.
      
"Header:PriceSchedule","Schedule Name","Base Schedule","Calculation Method","Calculation Factor","","","","","","""Header:Price","Customer Group","Price","Minimum","","","","","","","""Header:Product","Product Reference","Short description","Full description","Image filename","Price","Tax Treatment","Cost Price","Shipping data","Stock in hand","Stock checks enabled""Header:Section","Section Name","","","","","","","","","""PriceSchedule","15","Qty B","0","0","","","","","","""
      
     So I'v tried to do it with  tabs and windows ANSI
      
Header:PriceSchedule        Schedule Name    Base Schedule     Calculation Method    Calculation Factor
Header:Price    Customer Group    Price Minimum
Header:Product    Product Reference      Short description     Full description     Image filename     Price     Tax Treatment     Cost Price      Shipping data      Stock in hand      Stock checks enabled
Header:Section     Section Name

     It looks promising it is exactly what I need however Microsoft does again what it wants.

     The empty fields are still there and Microsoft does not recognize the new line and my tabs are gone

      

Header:PriceSchedule Schedule Name Base Schedule Calculation Method Calculation Factor       Header:Price Customer Group Price Minimum          Header:Product Product Reference Short description Full description Image filename Price Tax Treatment Cost Price Shipping data Stock in hand Stock checks enabled        Header:Section Section Name
      
     I also tried to put my information in one single field and export that, however with the same results.
      
     txt, csv, ANSI, Unicode , UTF-16, UTF-8  nothing helps.
      
Is there someone smarter than me who can fix my problem?wink
      
Many many many thanks for the help,
      
dirk
      

Outcomes