Hi
1. Where is the data coming from before you see it as a string? Can
you get at it from there??

2. The problem is still not well described enough to be coded up:
(a) C and D (and G?) in your list are text. How can they be
differentiated from each other? They will both have to not start with
U or they cannot be differentiated from F. Is that the case?
(b) E begins with a number. Does nothing else begin with a number (C,
D G and H specifically)?
(c) Is there anything in H to differentiate it from C, D, E, F and G?
What are US and CA formats by the way?

Presumably this string is being lifted from a database or webpage in
some way - if you can get at this source it would simplify things!

regards
Paul