I have a field that is a descriptio

[shrive22]

I have a field that is a description of a property name ex "adams 162 fake st", "applewood 354 main st", "heartland 555 straight st", "beechwood 789 oneway ave" etc. the description field also has the address in it. I was wondering if it is possible to use a formula to get the first word in the field (which is the location) and then use that for a group??

thanks for the help

 

[shrive22]

Is there any function that can extract just the first word out of a string???

thanks

 

[vidru]

Assuming that the first space is the end of the first word, then this works:

Mid ({Table.Field},1 , instr({Table.Field}," &quot)

You should be able to group on this without any trouble.

-dave

 

[shrive22]

thanks I'll try that.

 

[synapsevampire]

For use in a group try the following to allow for blanks:

if isnull({Table.Field})
or
instr({Table.Field}," &quot = 0 then
"No spaces"
else
left({Table.Field},instr({Table.Field}," &quot)

-k

 

[shrive22]

I used this formula

left({jobs.jobdescription},instr({jobs.jobdescription}
and it worked fine except for that there are a couple of records that in the desctiption the only thing that is in there is one word(the location). and with this formula it puts those records with just one word(the location) in the descption in there own group. I was wondering if theres a way to get them to be in the same group as the others

 

[vidru]

SV's formula should work for you. Here's a slight variation.

if
instr({jobs.jobdescription}," &quot = 0 then
{jobs.jobdescription}
else
trim(left({jobs.jobdescription}instr({jobs.jobdescription}," &quot))

-dave

 

[shrive22]

thanks a lot. it worked