May 27, 2015 at 10:16 pm
I have to figure out the items that Legal Name implies individual but Legal Entity Structure indicates a incorporation type. In this sample, you can see Alexander, Justin N. is my target. But my problem is how should I use a query to figure out which one is a individual's name? and any one can provide me the script with this question? How should I write a function to check the name format (Last, First Middle)? Thank you very much!
Legal Name ////////////////////////////////////// Legal_Entity_Struct
S & H Farm Supply, Ltd.////////////////////////////Company
F.M.Abbott Power Equipment,Co.///////////////Company
Ray's Dixie Chopper, Inc.////////////////////////// Company
Alexander, Justin N. ///////////////////////////////// Company
Alameda Power Equipment, Inc.//////////////// Company
Dun-Rite Appliance Co. Inc./////////////////////// Company
Edwards Furn. Of Crystal //////////////////////// Company
Baker's, Company ///////////////////////////////////// Company
Tennies Hardware, Inc.////////////////////////////// Company
Heinold and Feller Tire Co., Inc.////////////////// Company
Milton Village Hardware, Inc. ////////////////////// Company
Crane & Son, Inc./////////////////////////////////////// Company
Triple D Equipment, Inc///////////////////////////// Company
Merritt, Stephen C. //////////////////////////////////////Sole Propriertorship
Cane Equipment Cooperative, Inc. //////////////Company
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply