StNo Street Name
18880 Nordhoff Street #6

Desired result should be

StNo Street Name
18800 Nordhoff Street #6

The code below successfully copies just the street number away from the street address field and places it in the StNo field.

But it does not delete the street number from the original street address filed
leaving just the street name and all elements to the right of street name.

ANY IDEAS ON HOW TO DO THAT?
Thanks . . . Rick

method run(var eventInfo Event)
{breakApart method. This syntax is used to separate
the street number from the street name}
Var
ImpMoore1 table
ar Array[] String
tc tCursor
s,str String
si SmallInt
endVar
{-----------------------------------------------------------------}
addAlias("MYDIR","Standard","D:\\Pdoxwin7\\Moore")
{-----------------------------------------------------------------}
if Not tc.open("D:\\Pdoxwin7\\Moore\\ImpMoore1.db") then
errorShow()
return
endif
tc.edit()
scan tc:
str=tc."AddressDisplay".value ;field name in table
str.breakApart(ar, " ") ;use space as delimiter
for i from 1 to 1 ;limites data to the left of the first space in the field
str=ar[i] ;assigns data to str from left of first space in field
endfor

tc."StNo".value=str ;places str value in StNo field
endscan
tc.close()
endMethod

after : tc."StNo".value=str ;places str value in StNo field

tc."Address" = substr(tc.addressdisplay.value,length(str)+2, 40)

That will pull out the address beginning with the value after the space and including up to 40 characters thereafter. You can adjust it if the actuall addressplay field can be longer.

Lonnie

Hey Lonnie . . . that looks great. I'll try it as soon as I can and let you know how it works.

Thanks much!

Rick

Hi Lonnie . . .

tc."Address" = substr(tc.addressdisplay.value,length(str)+2, 40)

When I added this to my code as you suggested, I get the following error with the word "length" highlighted . . . Unknown Method Name

Any ideas . . ?

Thanks . Rick

tc."Address" = substr(tc.addressdisplay.value,str.size()+2, 40)

If you substitute this line (str.size() replacing length(str) it should work.

Of course that assumes that you have a field called address. If not you need to replace the tc."address" object with your field name.

Lonnie

Sheesh, I sure wish I had the intellegence you have Lonnie.

I have to fight just to get Paradox into edit mode. Ha!

I'll get back to you.

Thanks again . . . Rick

That fix did the trick.

Thanks . . . I mean THANKS MUCH for your help Lonnie.

Rick

Glad to do it!