No announcements
Found 984740 threads
-
0 VotesReplace function - special characters
create function dbo.SupaReplace(@string varchar(MAX), @badchars varchar(50) = '@$!Answered | 4 Replies | 1716 Views | Created by Murali dhar - Wednesday, April 30, 2014 4:11 PM | Last reply by Murali dhar - Wednesday, April 30, 2014 7:45 PM
-
1 Votes
Function to replace special character embedded with char into just character.
Some people will replace any character above 127 with a [?].Answered | 16 Replies | 4483 Views | Created by babbupunia - Friday, July 26, 2013 3:21 PM | Last reply by Naomi N - Monday, July 29, 2013 11:05 PM -
0 Votes
Find and Replace special Character
I have the below code to find(21 - Nak) and replace(133 - ...) a character in a text file.Answered | 6 Replies | 11769 Views | Created by zXSwordXz - Wednesday, September 19, 2012 7:10 PM | Last reply by zXSwordXz - Thursday, September 20, 2012 7:11 PM -
0 Votes
for Replace of 'number' with special character.
My problem is I have a temp table say #X and in it a coulmn PropertyValue In PropertyValue I have two values for ...Answered | 5 Replies | 1200 Views | Created by Prithviraj Singh - Wednesday, September 30, 2015 2:42 PM | Last reply by Naomi N - Thursday, October 1, 2015 3:47 PM -
1 Votes
Replacing special characters
As you've noticed, the hard part is knowing which are characters and which are markup.Answered | 7 Replies | 5075 Views | Created by Anand Venkatraman - Friday, November 29, 2013 4:11 AM | Last reply by David K. Downing - Wednesday, December 4, 2013 4:55 AM -
1 Votes
running into a problem with .replace and special characters
The acute accent alone is not a special character which is automatically placed above the other part of the character.Answered | 5 Replies | 2349 Views | Created by RLotter - Wednesday, October 5, 2011 5:11 PM | Last reply by Cor Ligthert - Thursday, October 6, 2011 6:07 AM -
0 Votes
Special characters are automatically replaced
When I type a 'special' character like é, à or ë in a PHP-file and close/reopen it, the character is automatically changed into � (the same ...Answered | 2 Replies | 3880 Views | Created by thomasvsundert - Sunday, May 18, 2008 3:54 PM | Last reply by thomasvsundert - Sunday, May 18, 2008 5:29 PM -
3 Votes
Regular Expression: How to replace special characters in a string?
>However, when it comes to these special characters \.*?Answered | 7 Replies | 11789 Views | Created by Joao Silverio - Thursday, October 5, 2017 9:37 AM | Last reply by Yong Lu - Monday, October 9, 2017 5:22 AM -
0 Votes
Replace special characters in ORACLE or SQL SERVER 2012 ?
0 BEGIN UPDATE @junk SET value = REPLACE(REPLACE( value, SUBSTRING( value, PATINDEX( @cmp, value ), 1 ),''),'-',' ') WHERE ...Answered | 5 Replies | 2262 Views | Created by Sergio S Arias - Monday, June 8, 2015 6:35 PM | Last reply by Sergio S Arias - Monday, June 8, 2015 8:31 PM -
0 Votes
How to replace special characters in csv file.
So I did that and the field wrote out to my SQL column correctly with no special characters.Answered | 9 Replies | 5208 Views | Created by bh0526999 - Thursday, June 4, 2015 12:35 PM | Last reply by Mr. Monkeyboy - Thursday, June 4, 2015 5:45 PM -
2 Votes
How can I replace an array of special characters in records?
TESTED -- Create a table Unwanted with text field Unwanted containing the characters to be replaced.Answered | 9 Replies | 2391 Views | Created by cfreema7 - Thursday, February 21, 2013 4:29 PM | Last reply by Vladimir Cvajniga - Thursday, February 21, 2013 8:27 PM -
0 Votes
Getting records with special characters
The special characters in Table 2 are !Answered | 15 Replies | 10682 Views | Created by babbupunia - Thursday, May 23, 2013 9:47 PM | Last reply by babbupunia - Wednesday, May 29, 2013 6:55 PM -
0 Votes
How do I extract special characters from a string, and then replace them?
Hi, plesae use String.Contains(...) to check if string contains special characters, and use String.Replace(...) to replace the characterAnswered | 2 Replies | 1350 Views | Created by Spawn10 - Friday, February 14, 2014 2:08 AM | Last reply by PaulLinton - Friday, February 14, 2014 3:58 AM -
0 Votes
Nullif for Special Character
I would suggest creating a clr based function that uses regular expressions - Regex.Answered | 5 Replies | 2223 Views | Created by AshishSingh_DWH - Wednesday, September 5, 2012 12:59 PM | Last reply by RohitGarg - Wednesday, September 5, 2012 2:19 PM -
0 Votes
Search strings with special characters
Hi Dikong42, One possible way could be that you replace the special characters from your column values before comparing against the user input ...Answered | 1 Replies | 1964 Views | Created by Dikong42 - Thursday, June 7, 2018 1:24 PM | Last reply by Ashish Kumar Tiwari - Thursday, June 7, 2018 3:15 PM -
0 Votes
Is there a way to remove special characters?
If you do not have many characters to replace using nested REPLACE function calls will be easy.Answered | 5 Replies | 4792 Views | Created by imsam67 - Thursday, June 3, 2010 7:44 PM | Last reply by imsam67 - Thursday, June 3, 2010 11:00 PM -
0 Votes
replace special characteres
Hi, Just take a look at this Link.Answered | 4 Replies | 804 Views | Created by Eswararao C - Friday, September 18, 2015 5:12 AM | Last reply by Jingyang Li - Friday, September 18, 2015 12:56 PM -
0 Votes
Replace function not working with Special Chars - Please help!
You can also invoke Regex class from SQL using CLR functions.Answered | 5 Replies | 832 Views | Created by Manesar - Wednesday, November 13, 2019 4:50 PM | Last reply by Viorel_ - Wednesday, November 13, 2019 8:28 PM -
1 Votes
Function to get all special characters in string
Refer the below user define function.Answered | 4 Replies | 7666 Views | Created by babbupunia - Friday, July 26, 2013 2:52 PM | Last reply by Prajesh - Friday, July 26, 2013 3:30 PM -
2 Votes
Special character in C#
There are more characters with special meaning in SQL, escaping just one of them for solving the one bug you've found isn't plugging the holes caused by the other bugs you ...Answered | 4 Replies | 6612 Views | Created by Haroon Nazir.S - Monday, October 3, 2011 7:41 AM | Last reply by Link.fr - Monday, October 3, 2011 2:22 PM - Items 1 to 20 of 984740 Next ›
No announcements
