Export to Text - Removing "QUOTES"

[thebenchman]

[updated:LAST EDITED ON Dec-07-07 AT 05:47 PM (EST)]I am exporting to a text file using specified delimiter (Double PIPE)__||____I do not want quotes around anything. I have a SKU field that is a character field but looks Numeric.____For example 03585____This exports to ||"03585"||____How can I get it so the "" do not appear?____Thanks

[thebenchman]

Here is a snipit from the file I created____"00083"||"00083"||Aconitum lycoctonum ssp. vulparia||"2008"||South||____It should read:____00083||00083||Aconitum lycoctonum ssp. vulparia||2008||South||____Whenever there is text that is a numbe - It puts in quotes

[kfleming]

This is the default behavior of text data export.____One alternative is to actually place the delimiter on the report layout and export to text rather than to text data.____Kathleen__R&R Support

[thebenchman]

Thanks,____That works fine - But now the .txt file has a bunch of spaces.____How can I concatenate everything together____I am getting this__ 00008 || Plastic Hum ^XX^ || || ||____When I realy want__ 00008||Plastic Hum ^XX^ ||||||____

[kfleming]

You need to change the alignment properties of each field to print at end of previous field rather than print at current position.____Kathleen__R&R Support