replace

Question

replace

bhushanhegde

Old Hand

Points: 382
More actions
December 5, 2008 at 11:01 pm

#216170

hi,
my sql out put is something like as follows:
in last row of my output i want to replace TERMINATOR="\t" with TERMINATOR="\r"
how can i do this...pls help me
bhushan

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

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

bhushanhegde (12/5/2008)
hi,
my sql out put is something like as follows:
in last row of my output i want to replace TERMINATOR="\t" with TERMINATOR="\r"
how can i do this...pls help me
bhushan

Please repost in this thread. I don't see anything to work with above.

dva2007 SSCertifiable Points: 7707 More actions · Answer 2

dva2007

SSCertifiable

Points: 7707

December 6, 2008 at 2:43 am

#908778

can u please write your query code?

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

BWAA-HAAA! Don't you guys know "vapor-ware" when you see it? It's obviously a "future release". :D:P:hehe:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

you sure its not dis appearing ink LOL

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Anam Verma SSCertifiable Points: 5365 More actions · Answer 5

from your invisible text i found something, may be you had put tabs in each line which i accidently found while highlighting your post.

so if you want to replace \t (tab) with \r (carriage return from every line, follow this code

declare @text varchar(255)

set @text = 'hi

hello

'

print 'before'

print @text

-- text replace statement

set @text = replace(@text,char(9),char(13))

print 'after'

print @text

by the way, why do you want o replace \t with \r.