SEPARATE WTH HYPHEN TO STRING again

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

sqlsurfing SSCarpal Tunnel Points: 4883 More actions · Answer 1

How are you determining where the Hypens will be inserted? Do you have a spec/business rule?

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

anuj12paritosh SSC Veteran Points: 295 More actions · Answer 2

hi

i have to solve with above senario and above mention condition is exists world

rVadim Hall of Fame Points: 3969 More actions · Answer 3

If you know positions you can use STUFF function:

SELECT STUFF('AD675498IJU76', 5, 0, '-')

SELECT STUFF(STUFF('AD675498IJU76', 5, 0, '-'), 8, 0, '-')

SELECT STUFF(STUFF('AD675498IJU76', 5, 0, '-'), 9, 0, '-')

--Vadim R.

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

DECLARE @hyphen VARCHAR(100) = '2,10',

@inputstring VARCHAR(max) = 'ABCDEFGHIJKLMNOPQRST',

@hyphen_count INT,

@i INT=1,

@key INT;

SET @hyphen_count = LEN(@hyphen) - ( LEN(REPLACE(@hyphen, ',', '')) ) + 1

WHILE @i <= @hyphen_count

BEGIN

IF ( CHARINDEX(',', @hyphen, 1) ) <> 0

SET @key = SUBSTRING(@hyphen, 1, CHARINDEX(',', @hyphen, 1) - 1)

ELSE

SET @key = @hyphen

SET @inputstring = STUFF(@inputstring, @key + @i, 1, '-')

SET @hyphen= SUBSTRING(@hyphen, @key + 1, LEN(@hyphen))

SET @i=@i + 1

END

SELECT @inputstring

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Lokesh Vij SSChampion Points: 10836 More actions · Answer 5

Create a function or stored procedure with @hyphen and @inputstring as arguments or parameters

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter