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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
