2 Replies Latest reply: Nov 15, 2011 4:57 PM by Frank Savino RSS

    How Do I Strip out Special Chars from a Cross Table

      Hi all,


      I've created a cross table and I want to strip out the following special characters (paretheses and quotes) but keep all alpha-numeric characters in my data field:


      " { } "

      How do I do this in QV developer or is it even possible?

      I tried using KeepChar and PurgeChar with no luck.

      as follows:

      CrossTable(Column1, Data)

      LOAD * FROM

      [C:\Documents and Settings\Frank\Desktop\cn.txt]

      (txt, codepage is 1252, no labels, delimiter is ',', msq)

      where keepchar ( '{"abcdefghijklmnopqrstuvwxyz"}','abcdefghijklmnopqrstuvwxyz' );


      Any Ideas would be greatly appreciated.