Find Character in String (2000)

Topic

New Reply

I know I used to know how to do this but can’t remember – I want to find the position of a particular character in text in a field so I can then split the data using left(), mid etc ie I want to find where the “-” appears in “Fred Nurks-40 Gan Gan Rd”

Reply | Quote

Replies

You can use the InStr function for this:

InStr([NameOfField],”-“)

will return the position of “-” in the field, or 0 if “-” does not occur.

Reply | Quote

Thanks (yet again) – I nearly had it but had the order wrong
Steve

Reply | Quote

Thanks (yet again) – I nearly had it but had the order wrong
Steve

Reply | Quote

You can use the InStr function for this:

InStr([NameOfField],”-“)

will return the position of “-” in the field, or 0 if “-” does not occur.

Reply | Quote