Will this expression return first word in string?

C

Cheryl Fischer

This might work better:

Left([NodeName], InStr([NodeName], " ") -1)

In the expression you supplied, you were passing a literal instead of a
field name and also searching for a null string, "", rather than " "
 
N

Nick Mirro

Left("NodeName",InStr("NodeName","")-1)


I am using it as criteria in a select query under field "NodeName." The
column (NodeName) has multiword text strings and I need the first word only.

When I run it, I get no records back, even if this is the only field. If
there is a problem, can I ask how to rewrite this? Thanks.

Nick
 
N

Nick Mirro

Hi and thanks for helping. No luck. I'm still getting an "invalid
procedure call" error as I did earlier. I set this as criteria for the
column I want to trim down.

Nick


Cheryl Fischer said:
This might work better:

Left([NodeName], InStr([NodeName], " ") -1)

In the expression you supplied, you were passing a literal instead of a
field name and also searching for a null string, "", rather than " "



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Nick Mirro said:
Left("NodeName",InStr("NodeName","")-1)


I am using it as criteria in a select query under field "NodeName." The
column (NodeName) has multiword text strings and I need the first word only.

When I run it, I get no records back, even if this is the only field. If
there is a problem, can I ask how to rewrite this? Thanks.

Nick
Click to expand...
Click to expand...
 
G

Graeme Richardson

If you're running this in as VBA code then you need a recordset reference

If you're running this as a query then you've posted to the wrong list, but
Left([NodeName],InStr([NodeName]," ")-1)
Will work everytime as long as you have at least one space in the field.

Hope this helps, Graeme.
 
P

PC Datasheet

Nick,

Putting the expression in the criteria is the wrong place! Put this expression
in an empty field in your query:

FirstWord:Left([NodeName], InStr([NodeName], " ") -1)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


Nick Mirro said:
Hi and thanks for helping. No luck. I'm still getting an "invalid
procedure call" error as I did earlier. I set this as criteria for the
column I want to trim down.

Nick


Cheryl Fischer said:
This might work better:

Left([NodeName], InStr([NodeName], " ") -1)

In the expression you supplied, you were passing a literal instead of a
field name and also searching for a null string, "", rather than " "



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Nick Mirro said:
Left("NodeName",InStr("NodeName","")-1)


I am using it as criteria in a select query under field "NodeName." The
column (NodeName) has multiword text strings and I need the first word only.

When I run it, I get no records back, even if this is the only field. If
there is a problem, can I ask how to rewrite this? Thanks.

Nick
Click to expand...
Click to expand...
Click to expand...
 
C

Cheryl Fischer

If you are using this in an Update Query, it should go on the Update to:
row, rather than the Criteria row.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Nick Mirro said:
Hi and thanks for helping. No luck. I'm still getting an "invalid
procedure call" error as I did earlier. I set this as criteria for the
column I want to trim down.

Nick


Cheryl Fischer said:
This might work better:

Left([NodeName], InStr([NodeName], " ") -1)

In the expression you supplied, you were passing a literal instead of a
field name and also searching for a null string, "", rather than " "



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Nick Mirro said:
Left("NodeName",InStr("NodeName","")-1)


I am using it as criteria in a select query under field "NodeName." The
column (NodeName) has multiword text strings and I need the first word only.

When I run it, I get no records back, even if this is the only field. If
there is a problem, can I ask how to rewrite this? Thanks.

Nick
Click to expand...
Click to expand...
Click to expand...
 
Top