/****************************************
** addresses.csv                       **
****************************************/
The following addresses are fictitious. They were created randomly and soley for the purposes of this example file. Any similarity to existing addresses or individuals is purely coincidental.

-----------------------------------------
SUBSTITUTION
Remove asterisk from zip field:
26,$s/\("[[:digit:]]\{5}\)\*\("\)/\1\2

Add quotations around zip code:
26,$s/\([[:digit:]]\{5}\)$/"\1"/

Delete the first field:
26,$s/^[[:digit:]]\{1,2},//

Change Neb. or Nebraska to NE:
26,$s/\("\)Neb\.\("\)\|\("\)Nebraska\("\)/\1NE\2/
------------------------------------------

GLOBAL EX COMMAND
Delete blank lines:
26,$g/^$/d
------------------------------------------

1,"Jordan","Kevin","930 Yorktown Ave.","Omaha","NE","68108*"
2,"Oberst","Charles","4530 Emmet Cir.","Omaha","Neb.","68112*"
3,"Stanard","Chris","3926 Rockbrook St.","Omaha","Nebraska","68104*"
4,"Tucker","Debra","5054 Davis Rd.","Omaha","NE","68154*"
5,"Dickens","Jack ","8805 Myrtle Ave.","Omaha","NE","68164*"
6,"Alloway","Jean","118 Taylor Blvd.","Omaha","NE","68124*"
7,"Jurgensen","Clayton","1155 36th St.","Omaha","NE","68022*"
8,"Steeb","Robert","12816 Seward Rd.","Omaha","NE","68135*"
9,"Widhalm","Roger","10011 Pine St.","Omaha","NE","68005*"
10,"Salvador","Stacey","5025 Martha Blvd.","Omaha","NE","68164*"
11,"Meier","James","914 Grant St.","Omaha","NE","68105*"
12,"Thompson","Brent","15916 188th Cir.","Omaha","NE","68135*"
13,"Pratt","Karen","3109 Erskine Rd.","Omaha","NE",68130
14,"Booker","Matt","3978 Camden St.","Omaha","Nebraska",68133
15,"Freeburg","David","4545 California Cir.","Omaha","NE","68107*"
16,"Keneko","Edward","11631 Lake Blvd.","Omaha","Neb.","68154*"
17,"Juster","Lori","3311 Capital Cir.","Omaha","NE","68107*"
18,"Franke","Jodi","2302 Canyon St.","Omaha","Nebraska",68107
19,"Ingram","Angela","3111 Jacobs Dr.","Omaha","NE","68005*"
20,"Cowan","Douglas","3302 30th Ave.","Omaha","Neb.",68116