Need To Remove Characters after "?" in URL 1

[JoeF]

I have imported a list of urls with several other fields i need to analyze, but I need to cut the characters after the "?" out of the URL field.

I was going to use a replace() formula to remove everything after the question mark, but i have no way of telling the formula what character to start the replace. If Access had a find() or a search() formula like excel, i could know the number of characters in the string to start the replace and then remove them. Is there a similar find or search function in Access?

 

[dhookom]

Access does have a find, it's Instr() which returns the position of one string within another.

Instr("Need to Remove","re") = 9

I expect this is enough info to get you going.

Duane
Hook'D on Access
MS Access MVP

 

[JoeF]

Worked like a charm. Thanks!

 

[PHV]

Worked like a charm
Even with URL without "?" ?
You may consider the Split function:

strResult = Split(strURL, "?")(0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

PH,
Very nice use of Split()

Duane
Hook'D on Access
MS Access MVP