Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Space
Message
From
21/05/2003 05:27:29
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Space
Miscellaneous
Thread ID:
00790954
Message ID:
00790958
Views:
17
This message has been marked as a message which has helped to the initial question of the thread.
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.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform