Question

Hi, i have a Problem in search. I want to search character string exactly like this, with spaces, quotation mark...

title="First Line Manager" value="Lisa"

%SEARCH{ " title="First Line Manager" value="Lisa" " nosearch="on" nosummary="on" regex="on" order="modified" web="Sandbox" topic="*Report"}%

But I can not get correctly result .

I also wrote as these formats, but they don't work too:(

%SEARCH{ " title=\"First&nbspLine&nbspManager\"&nbspvalue=\"Lisa\" " nosearch="on" nosummary="on" regex="on" order="modified" web="Sandbox" topic="*Report"}%

%SEARCH{ " title=\"First Line Manager\" value=\"Lisa\" " nosearch="on" nosummary="on" regex="on" order="modified" web="Sandbox" topic="*Report"}%

%SEARCH{ "title=\"First Line Manager\" value=\"Lisa\"" nosearch="on" nosummary="on" regex="on" order="modified" web="Sandbox" topic="*Report"}%

I can see the character string title="First Line Manager" value="Lisa" in back end, in all *Report.txt(I know search method is search value from what we can see from back end ".txt" files)

How can i do that? Appreciated very much...

Environment

-- ShashaLuan - 14 Jul 2006

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

Unfortunately quoting and escaping quotes in TWiki has always looked somewhat voodoo for me - but I know two workarounds. The first is do a regex search and replace the offending quote by a dot:

%SEARCH{ " title=.First Line Manager. value=.Lisa. " regex="on" }%

Let's do the search right now:

Results from Support web retrieved at 20:08 (GMT)

You may, per accident, find a topic containing the string title=1First Line Manager2 value=3Lisa4 - but I'd guess such strings are not encountered frequently....

Another workaround is to use single quotes ' in your topics. A string like title='First Line Manager' value='Lisa' should make absolutely no problems in a search.

-- HaraldJoerg - 14 Jul 2006

Thanks very much for your help :), but the character string format "title="First Line Manager" value="Lisa" " is original from the form(raw text of the form), so i cannot change as " "title=.First Line Manager. value=.Lisa. " " or "title=1First Line Manager2 value=3Lisa4"

-- ShashaLuan - 15 Jul 2006

You need to do a regex search as pointed out by Harald. I usually search this to catch just the meta data: "META:FIELD.*First Line Manager.*value.Lisa"=. To access the form field value in a FormattedSearch you can simply do a $formfield(First Line Manager) in your format parameter of SEARCH.

-- PeterThoeny - 15 Jul 2006

thanks very much, it works:)

-- ShashaLuan - 15 Jul 2006