Gareth Horton
July 12th, 2002, 01:33 PM
Hi Bo,
I wish I had better news for you, but, from what I see of the sample below, this is a very poorly constructed Report file.
There is no consistancy to the format. Even the labels are not consistant.
I can only see picking up the information as a Memo field. Trapping on the first Alpha (G and E)and using the End Field On option: Minimum Action Only. Splitting this Memo field will be difficult if not impossible due to the poor format. The varying data lengths and inconsistant placement of the information and labels.
Unfortunatly there are some files not much can be done with. I would suggest looking into generating this Report file differently.
Dee Moore
Datawatch Corporation
Technical Support
978.441.2200
Bo S. wrote:
> Hi,
>
> Does anyone have an example model showing how to properly trap an
> address with varying lines? I can't use the <zip> trap because in
> some cases another city state, zip line appears further down into
> the record. Here is some sample text illustrating my dilemma.
>
>
> 1 Guarantor..: DOE, JOHN
> 1 999999 PO BOX 99
> 1 510 ANYWHERE ST
> 1 ANYWHERE MS, 99999
> 1 Home Phone: 555-555-5555
> 1 Business Phone: 444-444-4444 Ext: 0000
> 1 Social Security #: 999-99-9999
> 1 Date of Birth/Sex: 99/99/99 - M
> 1 Last Receipt:
> 1 Employer...: SAM'S TOWN GAMBLING CASIN
> 1 HWY 61 & 304
> 1 TUNICA, MS 38676
> 1 999-999-9999 Ext: 0000
>
>
> As you see another CITY STATE, ZIP line occurs later in the record. So,
> when I use the <zip> trap the Employer line replaces the previous address.
>
> If I have not posted enough information I apologize, just tell me what else
> you would like to see. I think it worth mentioning that this is not a complete
> record. If a complete record is needed please tell and I'll post it.
>
> Thanks,
>
> Bo
I wish I had better news for you, but, from what I see of the sample below, this is a very poorly constructed Report file.
There is no consistancy to the format. Even the labels are not consistant.
I can only see picking up the information as a Memo field. Trapping on the first Alpha (G and E)and using the End Field On option: Minimum Action Only. Splitting this Memo field will be difficult if not impossible due to the poor format. The varying data lengths and inconsistant placement of the information and labels.
Unfortunatly there are some files not much can be done with. I would suggest looking into generating this Report file differently.
Dee Moore
Datawatch Corporation
Technical Support
978.441.2200
Bo S. wrote:
> Hi,
>
> Does anyone have an example model showing how to properly trap an
> address with varying lines? I can't use the <zip> trap because in
> some cases another city state, zip line appears further down into
> the record. Here is some sample text illustrating my dilemma.
>
>
> 1 Guarantor..: DOE, JOHN
> 1 999999 PO BOX 99
> 1 510 ANYWHERE ST
> 1 ANYWHERE MS, 99999
> 1 Home Phone: 555-555-5555
> 1 Business Phone: 444-444-4444 Ext: 0000
> 1 Social Security #: 999-99-9999
> 1 Date of Birth/Sex: 99/99/99 - M
> 1 Last Receipt:
> 1 Employer...: SAM'S TOWN GAMBLING CASIN
> 1 HWY 61 & 304
> 1 TUNICA, MS 38676
> 1 999-999-9999 Ext: 0000
>
>
> As you see another CITY STATE, ZIP line occurs later in the record. So,
> when I use the <zip> trap the Employer line replaces the previous address.
>
> If I have not posted enough information I apologize, just tell me what else
> you would like to see. I think it worth mentioning that this is not a complete
> record. If a complete record is needed please tell and I'll post it.
>
> Thanks,
>
> Bo