Topic
3 replies Latest Post - ‏2008-06-03T15:47:54Z by SystemAdmin
SystemAdmin
SystemAdmin
533 Posts
ACCEPTED ANSWER

Pinned topic single quote in Org name causing US preprocessor to classify incorrectly

‏2008-01-22T17:47:41Z |

I am running the us-domain preprocessor on name, address and area. A name can have an apostrophe in it and if it does, the name is getting pre-pended to the address domain and the name domain is left empty.

NAUSPRE | ADUSPRE | ARUSPRE
ABC Painting | 123 Main Street | Anycity MO 76230
___________| ABC's Quik Print 123 Main ST | Anycity MO 76230




stage looks like:
ZQNAMEZQ
NAME
ZQADDRZQ
ADDRESS1
ZQADDRZQ
ADDRESS2
ZQAREAZQ
CITY
ZQAREAZQ
ST
ZQAREAZQ
ZIP

Any info on how to capture those single quotes is greatly appreciated.

-Beth
QS Version 7.5 running on Unix

Message was edited by: BethCarey
Updated on 2008-06-03T15:47:54Z at 2008-06-03T15:47:54Z by SystemAdmin
  • Ray.Wurlod
    Ray.Wurlod
    18 Posts
    ACCEPTED ANSWER

    Re: single quote in Org name causing US preprocessor to classify incorrectly

    ‏2008-01-24T07:58:55Z  in response to SystemAdmin
    Is the single quote character among the characters in your SEPLIST? If so, remove it because it's causing the strings either side of it to be parsed separately.


    For related reasons, make sure that the single quote character does occur in your STRIPLIST.
    • SystemAdmin
      SystemAdmin
      533 Posts
      ACCEPTED ANSWER

      Re: single quote in Org name causing US preprocessor to classify incorrectly

      ‏2008-02-14T14:45:07Z  in response to Ray.Wurlod
      The pattern for ABC'S QUIK PRINT is @++. The USPREP is identifying this as an Address pattern. As far as the suggestion posted, the apostrophe is not in the SEPLIST or the STRIPLIST. By adding it to the STRIPLIST, it will make the data ABCS QUIK PRINT and change the pattern to + which does then go to the delimited default of Name. The question is, do you need the apostrophe in the Name for USNAME processing?

      Stewart
      • SystemAdmin
        SystemAdmin
        533 Posts
        ACCEPTED ANSWER

        Re: single quote in Org name causing US preprocessor to classify incorrectl

        ‏2008-06-03T15:47:54Z  in response to SystemAdmin
        Hi,

        Well, new project, new data and I am back to this issue. It is important that the apostrophe remain in the org name.

        -Beth