Replace Special Characters in SQL

Question

Replace Special Characters in SQL

ralahari

Old Hand

Points: 301
More actions
October 15, 2023 at 10:19 pm

#4308685

How to replace all special characters in SQL input
System.Text.RegularExpressions.Regex.Replace(input, "\{\*?\\[^{}]+}|[{}]|\\\n?[A-Za-z]+\n?(?:-?\d+)?[ ]?", "")
October 16, 2023 at 10:37 am

This was removed by the editor as SPAM
October 18, 2023 at 6:07 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246938 More actions · Answer 1

What sort of input? A file?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

ralahari Old Hand Points: 301 More actions · Answer 2

Input is Varchar(max) String column in Table.

I Need to replace all Special character in the input column with "".

(input, "\{\*?\\[^{}]+}|[{}]|\\\n?[A-Za-z]+\n?(?:-?\d+)?[ ]?", "")

Phil Parkin SSC Guru Points: 246938 More actions · Answer 3

This function might help you: https://www.sqlservercentral.com/scripts/patexclude8k

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin