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