Hi Moises,
you may do something like
lcIn = 'SLV640HF'
lcPart1 = ''
lcPart2 = ''
lnLoop = 0
DO WHILE !BETWEEN(SUBSTR(lcIn,lnLoop,1),'0','9')
lcPart1 =lcPart1+SUBSTR(lcIn,lnLoop,1)
lnLoop = lnLoop+1
ENDDO
DO WHILE BETWEEN(SUBSTR(lcIn,lnLoop,1),'0','9')
lcPart2 = lcPart2+SUBSTR(lcIn,lnLoop,1)
lnLoop = lnLoop+1
ENDDO
lcOut = lcPart1+' '+lcPart2+' '+SUBSTR(lcIn,lnLoop)
For each string you need to be converted.
HTH
Agnes
>I have a table with over 1,000 records with the field description
>on the format below
>
>BM146
>SLV640HF
>SLV660HF
>SLV676
>SLV676UC
>SLV686HF
>SLV696HF
>SLV696UC
>
>I would like to space between numbers and letters
>
>BM 146
>SLV 640 HF
>SLV 660 HF
>SLV 676
>SLV 676 UC
>SLV 686 HF
>SLV 696 HF
>SLV 696 UC
>
>Note that it's hard because some has three letter as prefix
>and other have two letters. Other has sufix and not
>
>TIA
>
>Moises
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]