Parse Query

[theif68]

I am looking to parse names that go into a table in the field "FULLNAME", but I only want this qry to run if there is 1 space in the field.

UPDATE tblStandardLayout SET tblStandardLayout.FNAME = Left([FULLNAME],InStr([FULLNAME]," ")), tblStandardLayout.LNAME = Mid([FULLNAME],InStr([FULLNAME]," ")+1);


This would be because I dont want it to try to parse names that are not just "First Last"

 

[traingamer]

add a where clause

where [FULLNAME] like "* *"

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Remou]

I think that checking for one space is not enough, I think you will have to check that there are not two spaces, perhaps something like:

[tt]Where Len(Trim(Fullname))-Len(Replace(Trim(Fullname)," ", "")=1[/tt]

 

[Remou]

... And Trim(Fullname & " ")<>""
to make sure that it is filled in.

 

[theif68]

Thanks guys.