Help with 'begins' Progress Results please

[Shadow Grass]

I am attempting to locate records that have a file link entered in my notes.noteln[2] field.

For example, this would be the data I am looking for: \\thisserver\thisfolder\nextfolder\file.pdf

If I do a BEGINS "\\", then I get everything that begins with \\ in that field, about 3,000 records.

However, I need to narrow that down, and when I enter BEGINS "\\thisserver" then I get zero results even though there are about 500 records that begin with \\thisserver.

I have done some searching here, but have not had a lot of luck. I am thinking that the slashes are somehow skewing the search. Any help would be appreciated.

 

[jmls]

I am attempting to locate records that have a file link entered in my notes.noteln[2] field.

For example, this would be the data I am looking for: \\thisserver\thisfolder\nextfolder\file.pdf

If I do a BEGINS "\\", then I get everything that begins with \\ in that field, about 3,000 records.

However, I need to narrow that down, and when I enter BEGINS "\\thisserver" then I get zero results even though there are about 500 records that begin with \\thisserver.

I have done some searching here, but have not had a lot of luck. I am thinking that the slashes are somehow skewing the search. Any help would be appreciated.

the \ is an escape character so, your initial begins "\\" actually is begins "\" - there are records that match this (all starting with \ and \)

this means that begins "\\thisserver" is actually begins "\thisserver" , but there are no records with this pattern

you could try begins "~\~\thisserver"

hth

 

[Shadow Grass]

I had actually read that backslash being escape character so I tried ~\\thisserver, but not what you recommended. That probably would have taken me another day to figure out at least Thank you very much, worked perfectly!