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:

ログインを記憶

パスワードを忘れましたか？

解決済み 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

There are no comments made yet.

返信 (3)

Sergey Pashkov 承諾済みの回答

Hello Jonathan,

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

There are no comments made yet.

Jonathan Ashwell 承諾済みの回答

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

There are no comments made yet.

Ruslan Zasukhin 承諾済みの回答

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

There are no comments made yet.

ページ :
1

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

返信するにはログインしてください

投稿するにはログインする必要があります。右側のフォームからログインするか、新規アカウントを作成してください。ここで登録 »

パスワードを忘れましたか？

解決済み Best way to escape text for RegEx search

Categories

Products

Support

Company