troubleshooting Question
Sql Server Trimming blank spaces
asked on
Hi, I have a view which users connect via Excel.
Now I have a table used in the view where there is column named 'NAME' and it has data with spaces at the end
and in between like below :
Andrew - there is single space here right at the end of the word
John - there is double space here right at the end of the word
Gareth Jones - there is double space here in between Gareth and Jones
Thirlestane Endurance E-3120, 36m tower -- there are 3 spaces before the 36m tower
so when in my function, I need to trim these spaces in my select statement like below -
all spaces at the end of the word needs to be removed
all double and more than double spaces in between the texts should be replaced with a Single Space.
Can anyone please give me that code which I can use in my SELECT ?
Many Thanks
Now I have a table used in the view where there is column named 'NAME' and it has data with spaces at the end
and in between like below :
Andrew - there is single space here right at the end of the word
John - there is double space here right at the end of the word
Gareth Jones - there is double space here in between Gareth and Jones
Thirlestane Endurance E-3120, 36m tower -- there are 3 spaces before the 36m tower
so when in my function, I need to trim these spaces in my select statement like below -
all spaces at the end of the word needs to be removed
all double and more than double spaces in between the texts should be replaced with a Single Space.
Can anyone please give me that code which I can use in my SELECT ?
Many Thanks
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.