Using a wildcard with the replace function

[razkowski]

Hello-

I'm attempting to use a wildcard with the replace function of a make table query. I have location information that looks like this:

Orlando, FL/Corporate


Tampa, FL/Sales
Atlanta, GA/Sales

I just want everything after the forward slash removed:

Orlando, FL
Tampa, FL
Atlanta, GA

I'm using the following and it's not working:

"Adjusted Location: Replace([Location],"/*"," ")"

Thanks in advance for any help you can provide.

[pbaldy]

Not sure Replace() is the way to go. I'd use Left() along with InStr(), presuming every record will contain the slash.

[razkowski]

Unfortunately, not all have the slash.

[pbaldy]

Still doable, you just have to add an IIf() with InStr() to test for it (InStr() will return 0 if it's not there).

[pbaldy]

This solution I gave on a similar thread may help:

Left(FieldName, IIf(InStr(1, FieldName,"/")>0,InStr(1, FieldName,"/")-1,Len(FieldName)))

[razkowski]

works beautifully. thank you

[pbaldy]

Happy to help!