Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 SEPARATE WTH HYPHEN TO STRING again Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, August 16, 2012 11:25 PM
 Grasshopper Group: General Forum Members Last Login: Friday, September 06, 2013 10:23 AM Points: 11, Visits: 132
 HI ALLI HAVE STRING SUPPOSESTRING :-AD675498IJU76I WANT TO SEPARATE WITH HYPHEN (-)BUT EVERY TIME POSITION IS NOT FIX.ASSUME FIRST TIME POSITION IS :- 4THEN RESULT : -AD67-5498IJU76ASSUME NEXT TIME POSITION IS :- 4,6THEN RESULT : -AD67-54-98IJU76ASSUME NEXT TIME POSITION IS :- 4,7THEN RESULT : -AD67-549-8IJU76I WANT TO DYANAMIC QUERY FOR SOLVE THIS PROBLEMTHANKS IN ADVANCE.
Post #1346334
 Posted Thursday, August 16, 2012 11:32 PM
 SSC-Enthusiastic Group: General Forum Members Last Login: 2 days ago @ 4:17 PM Points: 101, Visits: 753
 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
Post #1346335
 Posted Thursday, August 16, 2012 11:36 PM
 Grasshopper Group: General Forum Members Last Login: Friday, September 06, 2013 10:23 AM Points: 11, Visits: 132
 hi i have to solve with above senario and above mention condition is exists world
Post #1346336
 Posted Friday, August 17, 2012 12:17 AM
 SSC Eights! Group: General Forum Members Last Login: Thursday, October 10, 2013 12:51 AM Points: 957, Visits: 2,127
 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, '-')`
Post #1346342
 Posted Friday, August 17, 2012 12:17 AM
 Ten Centuries Group: General Forum Members Last Login: Monday, December 02, 2013 4:38 AM Points: 1,321, Visits: 1,501
 `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, ',', '')) ) + 1WHILE @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 ENDSELECT @inputstring ` ~ Lokesh Vij Guidelines for quicker answers on T-SQL questionGuidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.comFollow me @Twitter
Post #1346343
 Posted Friday, August 17, 2012 12:18 AM
 Ten Centuries Group: General Forum Members Last Login: Monday, December 02, 2013 4:38 AM Points: 1,321, Visits: 1,501
 Create a function or stored procedure with @hyphen and @inputstring as arguments or parameters ~ Lokesh Vij Guidelines for quicker answers on T-SQL questionGuidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.comFollow me @Twitter
Post #1346344

 Permissions