Home » Delete Horizontal White Space in SQL Serve

Delete Horizontal White Space in SQL Serve

When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white spaces along with the data, which may create a problem later.




If you want to delete whitespace around different lines of text in SQL Server Management Studio that can be done easily following below steps.

Lets see the sample data which contains white space, this data is copied from text file and paste into SQL Server Query Editor.

Lets view the white space first and later we will delete them.

Lets go to Edit menu in SSMS, after that click navigate to Advanced and select View White Space.

After clicking on View White Space, you can view white space in query editor window as shown below.

Now you can delete the white space, just select the text first as shown below.

Now go to Edit menu, navigate to Advanced then select Delete Horizontal White Space.

Once you click on Delete Horizontal White Space, you will see that white space are deleted.

 

Also Read..

Get Dark theme in SQL Server Management studio

Print Christmas Tree in SQL Server

Create an Ordinal Number ( that is 1st, 2nd, 3rd,..) in SQL



 443 total views,  1 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.