Notices
Union Talk For macro-level discussion: legislation, national unions, organizing pilot groups, etc.For airline-specific discussion, use relevant forum above.

ALPA database trick

Old 07-29-2022, 08:35 AM
  #1  
Gets Weekends Off
Thread Starter
 
Singlecoil's Avatar
 
Joined APC: Jan 2010
Position: Supine
Posts: 238
Default ALPA database trick

Geek Alert!
For any of you membership committee folks who have to deal with the excel data that ALPA provides, here is the code to break out the address from the single field they provide.
Their file has these columns:
Name, ALPA#, Cncl, Address, Email, Primary Phone, Cell Phone, Status, etc.
To break out the address, add 4 columns after Address like this:
Name, ALPA#, Cncl, Address, Street, City, State, Zip, Email, Primary Phone, Cell Phone, Status, etc.
and the code below is for those 4 new columns.

Column E
=LEFT(D2,FIND(",",D2,1)-1)
Column F
=MID(D2,FIND(",",D2,1)+2,FIND("~",SUBSTITUTE(D2,", ","~",2))-FIND("~",SUBSTITUTE(D2,",","~",1))-2)
Column G
=MID(D2,FIND("~",SUBSTITUTE(D2,",","~",2))+2,FIND( "~",SUBSTITUTE(D2,",","~",3))-FIND("~",SUBSTITUTE(D2,",","~",2))-2)
Column H
=MID(D2,FIND("~",SUBSTITUTE(D2,",","~",3))+2,LEN(D 2)-FIND("~",SUBSTITUTE(D2,",","~",3))-1)

I'm sure there a tons of ways of doing that, but it works.
Singlecoil is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
lake
Delta
183
04-08-2018 04:20 PM
Shortfall2105
FedEx
5
08-01-2017 06:56 AM
DarinFred
American
126
03-17-2016 02:20 PM
superduck
Union Talk
420
06-20-2011 10:00 PM
PEACH
Union Talk
8
03-30-2010 08:40 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Thread Tools
Search this Thread