Output in specific format

Question

Post reply

Output in specific format

sivaj2k

Ten Centuries

Points: 1188
More actions
December 12, 2014 at 5:16 am

#296024

Hi ,
I have sample data like 'J.S.xxxx','J.xxxx.'
Want to separate the . in the middle of word with single space and display results in following way.
J. S. xxxx
J. xxxx
Need the code in optimized way.
Siva

Viewing 4 posts - 1 through 3 (of 3 total)

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

Maddave SSCertifiable Points: 6828 More actions · Answer 1

You could just use a replace in your select

SELECT REPLACE(<columnName>, '.','. ')

FROM <tableName>

May not be efficient, but would work.

HanShi SSC-Dedicated Points: 33507 More actions · Answer 2

Have you already looked at this article

Tally OH! An Improved SQL 8K “CSV Splitter” Function By Jeff Moden[/url]?

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Maddave (12/12/2014)
You could just use a replace in your select
SELECT REPLACE(<columnName>, '.','. ')
FROM <tableName>
May not be efficient, but would work.

Actually if the data is consistent this is about the most efficient as you can do. It would run super fast even on millions of rows.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/