Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k.
If you can drop me the csv file (please not more than 3 mb). I can have a look. SL >Here is the challenge. > >Have a table with a column called NAME and the column contains both >names of businesses and individuals. Business names are stored as is , >example ABC Company. Individuals are stored as last name first name >middle initial, example Public John Q. I need to get this information >into another table where the biz name can be stored in the first name >field no problem but I need to parse and individuals name so I can put >the individual's first name in the first name column and their last >name in the last name column. > >Figure it out and I will send you a prize. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
