Page 1 of 1
Export to Text - Removing "QUOTES"
Posted: Fri Dec 07, 2007 5:46 pm
by 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
=> RE: Export to Text - Removing
Posted: Mon Dec 10, 2007 10:19 am
by 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
==> RE: Export to Text - Removing
Posted: Mon Dec 10, 2007 10:39 am
by 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
===> RE: Export to Text - Removing
Posted: Mon Dec 10, 2007 4:17 pm
by 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^ ||||||____
====> RE: Export to Text - Removing
Posted: Wed Dec 12, 2007 1:01 pm
by 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