Drop everything after a certain Character

[BIGPROFITT]

I have a Query with a field called a9RecipientName, that returns a text string. The text string is formatted like: LastName/FirstNames. I need to drop/trim all of the characters after the /.

Thanks

 

[KenHigg]

Something like:

left(instr("MyField","/")

 

[MSAccessRookie]

Something like:

left(instr("MyField","/")

Ken is right, but that command will leave the "/" at the end of the string. If you do not want the "/", then change it to

left(instr("MyField","/") - 1

 

[Brianwarnock]

Both Formulae are missing the closing )

Brian

 

[KenHigg]

left(instr("MyField","/")-1)

 

[Brianwarnock]

Ken he did say after / so maybe your first formula is the one he wants.

Brian

 

[KenHigg]

Whoops:

Left(MyField, InStr(MyField, "/") - 1)

 

[KenHigg]

Big has all of one post to his credit so I'm guessing we'll never know

 

[Brianwarnock]

Whoops:

Left(MyField, InStr(MyField, "/") - 1)

LOL so many experts so many simple errors, we read what we expect to see , glad you finally got it sorted , can we all take our dunces caps off now.

Brian

 

[KenHigg]

I try to beat everybody in on the so-called 'easy ones' and end up making a bunch of mistakes -

 

[MSAccessRookie]

I know what you mean. Even when I give credit to someone else, I forget the ")"

 

[Brianwarnock]

Its the easy ones we make the silly mistakes on as we tend to be complacent, I felt pleased with myself for spotting the missing ) , completely missed the missing fieldname.

Brian

 

[KenHigg]

I was trying to figure out how he could check to see if the '/' even existed before it was parsed so there wouldn't be an potential error but I don't think I'll waste my time