Best way to escape text for RegEx search

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

Angemeldet bleiben

Passwort vergessen?

Antwort hinzufügen Antworten ansehen (3)

Gelöst Best way to escape text for RegEx search

I've been using Valentina.EscapeString() for Regex searches, but the searches fail if they have characters like (, ), or ? I see these characters aren't being escaped properly to

\(
\)
\?

I can add the \ myself and now the Regex searches work.

What does Valentina.escapestring do, then? Should I roll my own escape method?

Valentina DB ADK

Kommentar

There are no comments made yet.

Antworten (3)

Sergey Pashkov Akzeptierte Antwort

Hello Jonathan,

Valentina.EscapeString() escapes ' and \ characters. The returned string can be safely used as a string (single-quoted) literal in the SQL query.

Kommentar

There are no comments made yet.

Jonathan Ashwell Akzeptierte Antwort

Thanks. So the answer is yes, we must escape any other reserved characters ourselves.

Kommentar

There are no comments made yet.

Ruslan Zasukhin Akzeptierte Antwort

Hi Jon,

we have seen that existed attempts to add REGEX chars to this function Valentina.EscapeString()
But later they were removed. We need to return back to this point I think

Kommentar

There are no comments made yet.

Seite :
1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Bitte melde Dich an um eine Antwort zu verfassen

Du kannst hierfür das Anmeldeformular rechts nutzen oder Dich registrieren. Hier registrieren »

Passwort vergessen?

Gelöst Best way to escape text for RegEx search

Categories

Database ADK

Support

Company