Thanks for your help in advance. Here is the deal. I get data off the internet that comes in long strings. I need to extract data out and assign them to columns. if the string looks like this:
Smith, Larry England -3,2
I need to get Smith as LAST NAME, Larry as FIRST NAME, England as COUNTRY, and -3,2 as HANDICAP. I already have the LAST NAME and HANDICAP figured out, it is the FIRST NAME and COUNTRY that are killing me. IDEAS??![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Smith, Larry England -3,2
I need to get Smith as LAST NAME, Larry as FIRST NAME, England as COUNTRY, and -3,2 as HANDICAP. I already have the LAST NAME and HANDICAP figured out, it is the FIRST NAME and COUNTRY that are killing me. IDEAS??