Quiz Extracts - Spaces and Quotes
Vissers, Wilbert
wilbert.vissers@hp.com
Wed, 25 Aug 2004 10:56:55 +1200
Hi Kristina,
The method we use is to set vertical bar | as the delimeter in Quiz, then use an editor to clean and adjust the output file afterwards. For example , change commas to dots, double quotes to singles, spaces to nothing, then finally change the vertical bars to the delimeter we want such as tab or comma or double quotes in your case.
Our editor is QEDIT, so for example after running quiz:
RUN QEDIT.PUB.ROBELLE;PARM=128;INFO="T TheFile;CQ','.'@;CQ'|','@;K,Y"
It works because vertical bar so rarely exists in text. A quiz prepass would identify if any do exist.
cheers
Wilbert