[AccessD] String Manip Help SOLVED

Drew/David

...thanks for putting my brain back in gear ...forgot to mention that the "
/Country" part of the string was often missing ...so I stuck it inside an
IIf and it works exactly as needed :)))))))))

IIf(InStr(1,[tblEMSINV]![CSZ],"
\")>0,Left([tblEMSINV]![CSZ],InStr(1,[tblEMSINV]![CSZ],"\")-1),[tblEMSINV]![
CSZ])

William Hindman
"You know the world is going crazy when the best rapper is a white guy, the
best golfer is a black guy, The Swiss hold the America's Cup, France is
accusing the US of arrogance, and Germany doesn't want to go to war."

----- Original Message -----
From: "Drew Wutka" <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, March 28, 2003 4:59 AM
Subject: RE: [AccessD] String Manip Help


> Sounds like you need to use InStr or InStrRev.
>
> something like
>
> Left([MyField],InStr(1,[MyField],"/")-1)
>
>
>
> -----Original Message-----
> From: William Hindman
> To: accessd at databaseadvisors.com
> Sent: 3/28/03 2:41 AM
> Subject: [AccessD] String Manip Help
>
> ...record field in table has a data string formatted like "city, state,
> zip
> /country" (without quotes)
> ...need to run an update query to remove the " /country" from each
> record
> where "country" can be any length
> ...any ideas appreciated :)
>
> William Hindman
> "You know the world is going crazy when the best rapper is a white guy,
> the
> best golfer is a black guy, The Swiss hold the America's Cup, France is
> accusing the US of arrogance, and Germany doesn't want to go to war."
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>