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

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

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

    ‏2008-01-24T07:58:55Z  
    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

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

    ‏2008-02-14T14:45:07Z  
    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.
    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

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

    ‏2008-06-03T15:47:54Z  
    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
    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