String manipulation in imported data
Posted by Andy Smithers on May 21, 2001 8:16 AM
I have what is probably a simple problem (to you guys anyway!).
I have a column consisting of data like:
C1 C2 C3-C17 C21
or
XP3 XP27-XP67 XP99
etc.
I need this converted to:
C1 C2 C3 C4 C5 C6 C7 C8 .....
or
XP3 XP27 XP28 XP29 XP 30 .....
Any help greatly appreciated.
Andy.