splitting a string

[MacSig]

Hello, this looks like a simple issue but since I'm a newbie scriptmaker I can't figure it out.

I have a field that contains a string, the string is formed by a arbitrary number of letters followed by 3 digits, for instance ABC001, ABCDE123. What I need to do is to split it into 2 parts, the first one has to contain the letters and the second one the 3 digits. I'm trying using "right" function but I couldn't make it so far.

Could you please let me know the best way to handle this kind of issues?

THANKS and HAVE A NICE DAY!

[Raybaudi]

letters = Left ( string ; Length ( string ) - 3 )

digits = Right ( string ; 3 )

Both fields MUST be text fields, not number fields.

[MacSig]

Thanks buddy, that's what I was looking for.

grazie Daniele, era esattamente quello che mi serviva : :

[Raybaudi]

grazie Daniele, era esattamente quello che mi serviva

Questo è perfetto italiano... ma lo sei ?

This is a perfect italian... but are you from Italy ?

[MacSig]

Si, anche se vivo in California

(yes, even if I Iive in California)

:hello: :hello: :hello: