How do I convert the Microsoft Word apostrophe to an HTML friendly apostrophe?

**TheDoc** · 10-17-2008, 02:52 PM

Replace them with: & #39 ;

**zentz** · 10-17-2008, 02:57 PM

which sql should i run?

**GrouchyAdmin** · 10-17-2008, 03:00 PM

update table set foo=replace(foo, 'bad', 'good');

**farkedup** · 10-17-2008, 03:11 PM

best tip is to not use MS word ;)

**zentz** · 10-17-2008, 03:13 PM

Originally posted by farkedup

best tip is to not use MS word ;)

thats the plan but i have to replace the existing ones

**Sosa** · 10-17-2008, 03:13 PM

Yeah, it sucks when text writers use word and then I throw it into dreamweaver and all the ' are fucked up

**zentz** · 10-17-2008, 03:17 PM

$20 epass to whoever gives me the correct query to execute.

**FlexxAeon** · 10-17-2008, 03:31 PM

Originally posted by GrouchyAdmin

update table set foo=replace(foo, 'bad', 'good');

give it to grouchy...

"table" = name of table
"foo" = field name
bad = that bad apostrophe
good = good apostrophe

Code:

UPDATE tablename SET fieldname = replace(fieldname, '*funky apostrophe here*', ''');

something like that

**zentz** · 10-17-2008, 03:39 PM

i tried this

update wp_posts set post_content = replace(post_content,'''', ''')

as funky apostrophe is showing as '' in mysql.

the error i get is:

ERROR: Unclosed quote @ 62
STR: '
SQL: update wp_posts set post_content = replace(post_content,'''', ''')

when i try to replace it with something else then ''' , example 'fuck' it works fine. any ideas?

**GrouchyAdmin** · 10-17-2008, 03:44 PM

You need to escape it. '\'' or '\"'.

**FlexxAeon** · 10-17-2008, 03:45 PM

Originally posted by zentz

i tried this

update wp_posts set post_content = replace(post_content,'''', ''')

as funky apostrophe is showing as '' in mysql.

the error i get is:

ERROR: Unclosed quote @ 62
STR: '
SQL: update wp_posts set post_content = replace(post_content,'''', ''')

when i try to replace it with something else then ''' , example 'fuck' it works fine. any ideas?

bah...my bad i was trying to edit my post and my boss walked in to talk lol...

dont use an actual apostrophe, use & #39 with space removed between & and 3

the funky apostrophe should carry over ok though if you copy/paste it directly from Word

**FlexxAeon** · 10-17-2008, 03:47 PM

or yeah escape it like grouchy just said (duh...forgot about that)

Code:

update wp_posts set post_content = replace(post_content,'*funky*', '\'');

How do I convert the Microsoft Word apostrophe to an HTML friendly apostrophe?

How do I convert the Microsoft Word apostrophe to an HTML friendly apostrophe?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment