Choose column separator in Exports

Options
Bangaltar112
Bangaltar112 Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor

When we export modules containing text-formatted line items and we choose csv or txt format, the column separator is automatically forced on 'comma'. If the text within the line item contains any comma in its body, it will shift the following columns and damage the whole file. 

 

It would be great to be able to choose the column separator when we select csv or txt in the export setup. 

Comments

  • Ramesh1992
    Ramesh1992 Member, ALL USERS, Partner Posts: 5 Master Anaplanner of the Year

    Hi is there a solution to this? 

  • seb_mcmillan
    seb_mcmillan Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 5 Master Anaplanner of the Year

    Not that I'm aware of

  • HalaBTB
    HalaBTB Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    I think it's an issue that has to be solved, we're facing the same problem

  • lleckenby
    lleckenby Member, ALL USERS, Partner, Certified Model Builder Posts: 1 New Contributor

    This would be a huge help at my current client who is requesting to have tab delimited exports.  Using the tabular single or tabular multi column formats does not produce a tab delimited output.  

  • robinnystrom
    robinnystrom Member, ALL USERS, Community Member Posts: 1 New Contributor

    I agree with the previous comments. This would be a huge help.