Searching Question (#)

[Totes]

We have a field that has this type of data:

093_f_GermanS_#01

Now of course if we try to search with for this record the # in the field it will not return the found record.

So,is there any way to search for this record with the # being part of the data?

Thanks,

Jim

Edited August 4, 2009 by Guest

[comment]

You need to escape the # wildcard character - search for:

093_f_GermanS_#01

---

BTW, this looks like a major departure from the 'one fact per field' rule.

[Totes]

Thanks Comment,

If you think this is a departure form the one fact per...you should see some of their other data :.

I did not even notice this until after we imported their records.

The big problem is that the K9 officers had no set standard for their system before, so I may have:

456#23_07_F-GermanS or 2005-GermanS#22F

Thanks for the reply.

Jim

Edited August 4, 2009 by Guest

[comment]

Is it possible to put the "" at the start of the search

No.

is ther a way to have the "" attached to the data being searched entered into the field automatically?

If the search is scripted, you could substitute "#" with "#".

Or perhaps use a script trigger (if in Find mode, and keystroke is "#"...).

But overall, I believe cleaning up the data would be time better spent.

[Totes]

Yep once again you are correct, I think cleaning up only 80 or so records will be much easier than attempting to teach them how to search in this mess and they forget it all tomorrow.

Thanks again...Im off to clean up data Wheeeeeeeee!