Re: [MSAccessProfessionals] Split full name into first and last fields

The full name is coming out of our Financial Software so I don't control it. That is why I want to split it apart so I have better control over it. 

Sample data:
TENANTNAME
Iron Hawk, Manny                                                
Iron Hawk, Tallie                                               
Iron Bird, Inez                                                 
Iron Lightning, Robinn                                          
Iron Lightning, Veronica                                        
Iron Hawk, Margo                                                
Iron Hawk, Matthew                                              
Iron Wing, Roxanne                                              
Iron Hawk, Wayne                                                
Iron Wing, Chauncina                                            
Iron Wing, Barbara                                              
Iron Wing, Carrie                                               
Isna, Roderick                                                  
Active PD, Alan Jamerson                                        
Active PD, Gary Janise                                          
Janis, Henrietta                                                
Janis, Jesse                                                    
Janis, Lucinda                                                  
Janis, Marletta                                                 
Janis, Patience                                                 
Janis, Vanessa                                                  
Jeffries, Jenny                                                 
Jeffries, Lowan                                                 
Jeffries, Milton                                                
Jeffries, Wade                                                  
Jensen, Diana                                                   
Jeunesse, Madeline                                              
Jewett, Cecelia                                                 
Jewett, Cyril                                                   
Jewett, Francis/Arllen                                          
Jewett, Frank                                                   
Jewett, Gregory                                                 
Jewett, Iyonne                                                  
Jewett, Louis                                                   
Jewett, Nina                                                    
Jewett, Samantha                                                
Johnson, Adell                                                  
Johns, Todd                                                     
Johnson, Tyllia                                                 
Johnson, Vivian                                                 
Jones, Neccia E.                                                
Kasto, Naomi                                                    
Keckler, Arliss                                                 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115556) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_