Exporting to tab delimited txt file format

@dcote70 

Derek,

Could you please inform me of the version you are using?

I have just tested and the values or Delimiter Field under Data Provider Parameters should be available as a drop down list and TAB is also an option you can select.

If the field is not a drop down please check latest build in 2019R2 or 2020R1.

This functionality was delivered as per following feedback request in 2019R2. https://feedback.acumatica.com/ideas/ACU-I-1473

Sam Kabiri

I am glad that I could be of some help.

@hkabiri Do you know of any workarounds in 2019R1? We are intending on upgrading in early 2021, but this is more of an immediate need.

This can also be done with a CSV data provider with single field output. In your Export Scenarios, use a formula to conact all your fields together with a quoted tab character seperating each field. Map this to your single column in your data provider. 

Example:

To inject the tab, use notepad to copy a tab character and insert it between quotes in the Concat function.

@RoyceLithgo Would you mind sending another screenshot or two of how you set up your data provider in this case? 

It’s a basic CSV with a single field.

Just use default values on the Parameters page.