Finding Text After the first Space in field 1

[crzycrystlgrl]

hello all
CR 9 -- - SQL/ODBC

does anyone know of a why to have crystal recognize the first space in a text field?
I am trying to figure out a way to extract just the street name from an address field...and since the street numbers are anywhere from 1-6 char long...I am not sure where to start.
if there was some kind of "opposite" key for the val function?
thanks
Cynthia

 

[kskid]

Try this

if isnull({table.field}) then
    "No Street"
Else If Instr({table.field}," ")>0 then
    Mid({table.field},(Instr({table.field}," ")+1))
Else
   {table.field}

-LW

 

[crzycrystlgrl]

you are a genius!!!!!