No announcements
Found 3168194 threads
-
0 VotesFind and Replace special Character
And apparently opening it with a program which doesn't know how to open it.Answered | 6 Replies | 11728 Views | Created by zXSwordXz - Wednesday, September 19, 2012 7:10 PM | Last reply by zXSwordXz - Thursday, September 20, 2012 7:11 PM
-
0 Votes
how to replace a character in SSMS
1) Press CTRL + H (Replace) 2) On Find and Replace Winow select the downarrow mark on Quick Replace Tab and select ...Answered | 5 Replies | 15685 Views | Created by light_wt - Sunday, January 3, 2010 10:26 PM | Last reply by light_wt - Tuesday, January 5, 2010 2:29 PM -
0 Votes
Replacing invalid characters in a field
It really depends on how big the replace list is and how often it changes...Answered | 4 Replies | 1239 Views | Created by John Couch - Tuesday, October 6, 2015 11:14 PM | Last reply by --CELKO-- - Wednesday, October 7, 2015 3:14 AM -
0 Votes
Replace function - special characters
Take a look at this article T-SQL: How to Find Rows with Bad Characters and check See Also section in that ...Answered | 4 Replies | 1702 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
How to find unknow characters
It will take care of finding strings with UNICODE characters, but not umlaut characters (e.g. ü or ä, Talking about confusing ...Answered | 13 Replies | 6761 Views | Created by KayJHut - Friday, February 12, 2010 7:22 PM | Last reply by Kalman Toth - Friday, February 12, 2010 9:05 PM -
0 Votes
Replacing characters in a string feature
Hi MS_Prog, You can use R script within the 'Execute R Script' module to do a string replacement.Answered | 1 Replies | 442 Views | Created by MS_Prog - Monday, December 5, 2016 5:14 AM | Last reply by Jaya Mathew - Monday, December 5, 2016 4:54 PM -
2 Votes
Find characters, replace them
(Ctrl+H) to replace the values you want in the file.Answered | 8 Replies | 1121 Views | Created by miniHessel - Friday, November 2, 2012 9:25 AM | Last reply by miniHessel - Thursday, November 22, 2012 9:14 AM -
2 Votes
C# replace character
So there shouldn't be any double backslash left after the strings have been acted on by the Path.GetFullPath() method.Answered | 7 Replies | 2271 Views | Created by wendy elizabeth - Tuesday, October 16, 2012 1:54 PM | Last reply by Louis.fr - Wednesday, October 17, 2012 6:37 AM -
4 Votes
Help on replacing characters
ya i got that Thanks .... i used this UPDATE tblperson SET Phone = ...Answered | 21 Replies | 1393 Views | Created by coolguy123SQL - Tuesday, February 26, 2013 6:17 PM | Last reply by Johnny Bell Jnr - Wednesday, February 27, 2013 12:21 PM -
1 Votes
How to replace a character at a random position of a column in SQL Server 2000?
Your problem is most likely the source data has a CR and/or LF after it in the database.Answered | 3 Replies | 1674 Views | Created by Bangaaram - Wednesday, September 24, 2014 7:03 PM | Last reply by Bangaaram - Wednesday, September 24, 2014 8:12 PM -
2 Votes
How to make a program that replaces the characters?
I'll try to see if I can find a Font creating program in VB.Net if that's what you are thinking about doing.Answered | 13 Replies | 727 Views | Created by GraczSzymon - Wednesday, July 1, 2015 9:36 PM | Last reply by IronRazerz - Friday, July 3, 2015 12:35 PM -
1 Votes
How to replace characters in a string?
This means that characters in arrayTypingError which are beyond the index of the length of the string will not be considered.Answered | 3 Replies | 935 Views | Created by Melanuska - Friday, November 1, 2013 12:59 AM | Last reply by PaulLinton - Friday, November 1, 2013 8:55 PM -
0 Votes
Find fist character if its '-' and replace space
Hi, need to find the fist character if its '-' and replace space in the derived column.Answered | 1 Replies | 629 Views | Created by kccoolrocks - Tuesday, August 12, 2014 7:51 AM | Last reply by Visakh16 - Tuesday, August 12, 2014 8:33 AM -
0 Votes
Replace special characters in ORACLE or SQL SERVER 2012 ?
I'm using SQL SERVER 2012 and I found similar solutions using PATINDEX, but they still use loops to face the problem; I've been working with SQL SERVER for 5 years and I think the ...Answered | 5 Replies | 2247 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
Replace characters in file
Powershell can do this replace, but you might want to watch the size of the file you operate on.Answered | 2 Replies | 1261 Views | Created by jdb09 - Sunday, February 23, 2020 9:06 PM | Last reply by MartinJaffer-MSFT - Friday, February 28, 2020 7:09 PM -
0 Votes
How to Find & Replace in a table
Using SQL Server Studio Express 2005 only to make very simple database updates to the SQL product file that my shopping cart uses for my web site.Answered | 1 Replies | 5331 Views | Created by MarcoM0857 - Tuesday, July 5, 2011 9:52 PM | Last reply by Mr. Wharty - Wednesday, July 6, 2011 12:52 AM -
0 Votes
SQL Wild Character Before and after String
Take a look at this blog post and the comments to it http://beyondrelational.com/blogs/naomi/archive/2011/10/19/remove-bad-characters-from-a-string.aspx For every ...Answered | 4 Replies | 3725 Views | Created by MS308 - Tuesday, January 3, 2012 12:37 PM | Last reply by SimpleSQL - Tuesday, January 3, 2012 2:18 PM -
0 Votes
How does Find & Replace work in SSMS?
http://ask.metafilter.com/71722/SQL-Server-Find-and-Replace-Script http://tgrignon.wordpress.com/2008/11/20/search-and-replaceAnswered | 4 Replies | 4408 Views | Created by banksidepoet - Saturday, February 4, 2012 1:12 PM | Last reply by banksidepoet - Monday, February 6, 2012 1:17 PM -
0 Votes
Finding string between characters
I have to find two strings ("&#" and ";), extract the number represented by the characters between them, then replace the whole thing (from ...Answered | 15 Replies | 861 Views | Created by Brian D. Hart - Thursday, July 30, 2015 4:50 PM | Last reply by Mark18991230 - Wednesday, August 5, 2015 11:16 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 | 5174 Views | Created by bh0526999 - Thursday, June 4, 2015 12:35 PM | Last reply by Mr. Monkeyboy - Thursday, June 4, 2015 5:45 PM - Items 1 to 20 of 3168194 Next ›
No announcements
