I want to extract the records which have a space in between the words from position 53 to 79 just before any of these characters
ACR, ALY, APR, APT, AVE, BCH, BLF, BLV, BND, BRG, BRK, BWY, CIR, CLF, CLS, COM, CON, COR, CRT, CST, CT, CTF, CTR, CV, CY, DR, E, EL, END, EST, EXP, EXT, FLD, FLT, FRM, FRS, FUR, GDN,GLA, GLN, GRN, GRV, GT, HBR, HGL, HL, HLS, HLW, HOL, HTS, HVN, HWY, IS, ISL, KNL, LK, LN, LND, MDW, MWS, N, NCK, NS, OVA, PD, PIK, PK, PKY, PL, PLN, PLZ, PNE, PSS, PT, PTH, RD, RDG, RDY, RIV, ROW, RS, RUN, S, SHL, SHR, SLP, SQ, ST, STR, TER,TPK, TRL, TWR, VLG, VLY, VW, W, WAY, WLK, XIN
For Example in the above code I have BARD-GRAM CIR which is valid, however in the next record it has WARD GRAM ST which is incorrect. I want to have these types of records in my output file with the same record layout as my input.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
I have some questions/clarifications:
What do the dots in the records represent (spaces, binary zeros, something else-what)?
If each word preceded by blank in your record has word in the list, then you want to keep the record - right?
If any word preceded by blank in your record does not have word in the list, then you want to delete the record - right?
The second record should be deleted because it has bGRAM and GRAM is not in the list, even though it also has bST and ST is in the list - right?
The third record should be kept because it only has bST and ST is in the list - right?
Your example has a maximum of three words in the field. Is 3 the actual maximum or can there be more than 3 words in a field - how many?
The format from record 53 is a Street Name followed by any of the suffixes like ST, CIR etc.
The Street name can be of any length followed by any of the suffixes, so there is not fixed length of the Street Names, but the Street Name will be followed by any of the suffixes as I have listed above.
The suffixes have a maximum length of 3, there would be a space after the Street Name and the Suffix.