How do i replace string in this scenario ?

alvincks · #1 (**permalink**) 12-27-08, 11:53

Good day,

When i using following query to pull out the data as following :-

Code:

SELECT url FROM mytable

the url data will show following :-

Code:

<object width="480" height="385"><param name="movie" value="http://www.youtube.com/v/RXbnq5eW0vo&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/RXbnq5eW0vo&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385"></embed></object>

but i would like to replace the width and height in specific value say width=200 , height=300 for both occurance, how can i do that ?

meaning i would like to get the data after specific value replaced as show in following :-

Code:

<object width="200" height="300"><param name="movie" value="http://www.youtube.com/v/RXbnq5eW0vo&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/RXbnq5eW0vo&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="200" height="300"></embed></object>

many thanks for guidance !

gvee · #2 (**permalink**) 12-29-08, 08:40

width and height appear twice, and you're wanting to change both...

If you're going to be doing this often it may be advised to store it in the db with the format

Code:

<object width="[width]" height="[height]" ...

Because this would make the replacements super easy

r937 · #3 (**permalink**) 12-29-08, 09:43

better yet, store the url along with its attributes and construct the html from those values -- don't store the actual html itself

gvee · #4 (**permalink**) 12-29-08, 09:43

Even better suggestion! ++1

alvincks · #5 (**permalink**) 01-01-09, 07:26

Thanks all for reply,

but the case here is the URL is user enter, in most case, the URL should take the width and height value from user , only in certain page, the movie need to display in specific size , any chance i can get it replace ?

alvincks · #6 (**permalink**) 01-01-09, 22:54

Hi George, i might be little dumb here, do you mind to explain further how your sample can be replace easily ?

r937 · #7 (**permalink**) 01-01-09, 22:58

yeah, george, go for it!

gvee · #8 (**permalink**) 01-02-09, 04:01

It's called Replace()

Code:

SELECT Replace([field_name], '[string_to_find]', '[string_to_replace]');

alvincks · #9 (**permalink**) 01-04-09, 08:41

Thanks George !

what if the situation here insist me on just change the width and height ?

what can i do for it ?

Code:

<object width="200" height="300"><param name="movie" value="http://www.youtube.com/v/RXbnq5eW0vo&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/RXbnq5eW0vo&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="200" height="300"></embed></object>

gvee · #10 (**permalink**) 01-05-09, 04:03

There's obviously a flaw, but here you go!

Code:

Replace(Replace(your_field_containing_the_url, '200', new_width_value), '300', new_height_value)

alvincks · #11 (**permalink**) 01-05-09, 05:26

Thanks George !!!
i forgot to mentioned the value of width and length is variable which depend on user define value actually

gvee · #12 (**permalink**) 01-05-09, 06:17

Exactly! Which is why you need to reconsider the way in which you store the data.

Internet Services

Web Development

Digital Marketing

Consumer Tech