Topic Options
#114 - 07/08/99 06:37 AM QRW 6.5 export options
Anonymous
Unregistered


Hi,

I am presently using QRW to export info from a Peresoft product (TRAVPAC).

My customer requires the export as a "TAB SEPERATED TEXT FILE".

After the export, the fields are enclosed with the " character. Which he does not want!
Also if one of the fields was not captured, the export does not allow an empty space for that field.

I hope you can help!

Thanks
Russell Fogg


Top
#115 - 07/08/99 08:00 PM Re: QRW 6.5 export options
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11324
Loc: Vancouver, BC Canada
Hi Russell,

You are correct that in most export formats, the string values are surround by double-quotes. I did find that the export did leave spaces for blank fields, though, for the tab-separated text format.

If you want to perform an export with all fields separated by tabs, and not surrounded by double-quotes, you can do this in 2 steps. First, do the export in the character separated values format. This will allow you to export without the quotes. Unfortunately, you cannot have a tab as the separating character. What you should do is use a character that will not be in any of the fields, such as the tilde ~.

Next, open the export file in Word, and use the "Replace All" function to replace every ~ character with the special tab character (^T). This will create the export format your client requires.

[This message has been edited by Softrak Support (edited 07-30-99).]


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 25 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31