Recent content by catman60

CJ, many thanks. Seems I'm having no difficulty in removing the #, however, I'm left with: Mark Hollings;14664;Judy Thompson;10169;Tammy Wilson;3608;Tim Levy;2785;David Simpson;1251 Any suggestions for extracting only the text or now replacing numeric content that can vary? Thanks

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...