Extracting from an unusual string

jeudi 5 mars 2015

Ok. First post here guys so go easy on me please. I have a flat file sent to me today that contains a number of fields with the same issue. As an example, I have a field named Coordinators from a table named Audit and the data within it is formatted as follows:



Mark Hollings;#14664;#Judy Thompson;#10169;#Tammy Wilson;#3608;#Tim Levy;#2785;#David Simpson;#1251



Is there any way to extract only the names while leaving in either the ";" or replacing it with a ","? My desired output would look like this:



Mark Hollings;Judy Thompson;Tammy Wilson;Tim Levy;David Simpson



This field can be poplulated with one or more names so that's a variable in all of this as well.



Thanks!

Extracting from an unusual string

0 commentaires:

Enregistrer un commentaire

Labels