topic Re: regex to not match number,character, space(between) in Dashboards & Visualizations

regex to not match number,character, space(between)

zacksoft_wf — Thu, 30 Sep 2021 13:43:15 GMT

Need help with a regex to show me if the input field has spaces at the leading or ending of the string OR if it contains " <doublequotes> anywhere in the string.

<change>
<eval token="validationResult" >if(match(value, "[^\"a-zA-Z0-9]"), "padded space or doublequote identified", "All Good"</eval>
</change>

Re: regex to not match number,character, space(between)

PickleRick — Thu, 30 Sep 2021 14:54:04 GMT

(\s$|^\s|")

As simple as that - you match whitespace at the end OR whitespace at the beginning OR doublequotes just about anywhere. Just remember to do proper backslash-escaping.

Re: regex to not match number,character, space(between)

zacksoft_wf — Fri, 01 Oct 2021 05:57:45 GMT

It's not working .

=============================================
<form>
<label>TextBox Validation</label>
<fieldset submitButton="false">
<input type="text" token="selText">
<label>Enter your Input (Dont add heading or trailing space or double quotes)</label>
<change>
<eval token="validationResult">if(match(value, "(\s$|^\s|")), "Space Padding or double quote identified", "No Error Identified"</eval>
</change>
</input>
</fieldset>
<row>
<panel>
<table>
<search>
<query>| makeresults
| eval Text="$selText$ has $validationResult$"
| table Text</query>
<sampleRatio>1</sampleRatio>
</search>
<option name="count">20</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</option>
<option name="percentagesRow">false</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
</table>
</panel>
</row>
</form>

=============================================

Re: regex to not match number,character, space(between)

PickleRick — Fri, 01 Oct 2021 07:15:09 GMT

"Just remember to do proper backslash-escaping."

You'd probably need to do something like

(\\s$|^\\s|\"))

In order to escape the regex as a string