How do I separate a string into alpha and numeric parts?

[bigcat]

I have lists like the following and need to separate the strings into the alpha and numeric components in separate fields. Any help will be much appreciated.

Thanks

ORIGINAL FLD1 FLD2
FCV1031 FCV 1031
FCV1033 FCV 1033

 

[fyrewall]

Looking at your example, you could use left$(Original,3) and right(Original,4) to split it up. If you don't know how many alpha characters there are, you could use the val() function to look at the value of each character. If the value is zero and the character <> &quot;0&quot; then it's a letter.

Hope this helps a bit.

Fyrewall