Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
forever_newbie forever_newbie is offline
external usenet poster
 
Posts: 2
Default How do I get rid of strange special characters?

I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes (sql
server doesn't like seeing single apostrophes in the middle of a text field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). When you try and replace one apostrophe by two, you get a
reverse slanted character followed by an apostrophe. Since I didn't notice
this, I went ahead and inserted the word as text into a sql field, and now
my sql database is full of these characters. I have to get rid of them, so
the question is - what are they?
Thanks,


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I get rid of strange special characters?

Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"forever_newbie" wrote in message
...
I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes
(sql
server doesn't like seeing single apostrophes in the middle of a text
field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). When you try and replace one apostrophe by two, you get
a
reverse slanted character followed by an apostrophe. Since I didn't
notice
this, I went ahead and inserted the word as text into a sql field, and
now
my sql database is full of these characters. I have to get rid of them,
so
the question is - what are they?
Thanks,




  #3   Report Post  
Posted to microsoft.public.word.docmanagement
FOREVER_NEWBIE FOREVER_NEWBIE is offline
external usenet poster
 
Posts: 3
Default How do I get rid of strange special characters?

No, its not a grave accent. Try it yourself - create a word such as
Mary's and then do a search/replace of the apostrophe by 2
apostrophes. At least in Word 2000, it creates 2 characters, and
neither of them are a grave character.
-- Thanks

On Jan 27, 6:05*pm, "Suzanne S. Barnhill" wrote:
Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org

"forever_newbie" wrote in message

...

I had a word article that I was going to insert into sql server in a text
field. *So I replaced every occurrence of apostrophe by two apostrophes
(sql
server doesn't like seeing single apostrophes in the middle of a text
field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). *When you try and replace one apostrophe by two, you get
a
reverse slanted character followed by an apostrophe. *Since I didn't
notice
this, *I went ahead and inserted the word as text into a sql field, and
now
my sql database is full of these characters. *I have to get rid of them,
so
the question is - what are they?
Thanks,


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I get rid of strange special characters?

I would expect an opening single quote in this context.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"FOREVER_NEWBIE" wrote in message
...
No, its not a grave accent. Try it yourself - create a word such as
Mary's and then do a search/replace of the apostrophe by 2
apostrophes. At least in Word 2000, it creates 2 characters, and
neither of them are a grave character.
-- Thanks

On Jan 27, 6:05 pm, "Suzanne S. Barnhill" wrote:
Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org

"forever_newbie" wrote in
message

...

I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes
(sql
server doesn't like seeing single apostrophes in the middle of a text
field).
What I didn't notice was that this replace doesn't work the way you
would
expect (in Word). When you try and replace one apostrophe by two, you
get
a
reverse slanted character followed by an apostrophe. Since I didn't
notice
this, I went ahead and inserted the word as text into a sql field, and
now
my sql database is full of these characters. I have to get rid of them,
so
the question is - what are they?
Thanks,



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I get rid of strange special characters?

I would expect an opening single quote in this context.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"FOREVER_NEWBIE" wrote in message
...
No, its not a grave accent. Try it yourself - create a word such as
Mary's and then do a search/replace of the apostrophe by 2
apostrophes. At least in Word 2000, it creates 2 characters, and
neither of them are a grave character.
-- Thanks

On Jan 27, 6:05 pm, "Suzanne S. Barnhill" wrote:
Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org

"forever_newbie" wrote in
message

...

I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes
(sql
server doesn't like seeing single apostrophes in the middle of a text
field).
What I didn't notice was that this replace doesn't work the way you
would
expect (in Word). When you try and replace one apostrophe by two, you
get
a
reverse slanted character followed by an apostrophe. Since I didn't
notice
this, I went ahead and inserted the word as text into a sql field, and
now
my sql database is full of these characters. I have to get rid of them,
so
the question is - what are they?
Thanks,





  #6   Report Post  
Posted to microsoft.public.word.docmanagement
FOREVER_NEWBIE FOREVER_NEWBIE is offline
external usenet poster
 
Posts: 3
Default How do I get rid of strange special characters?

No, its not a grave accent. Try it yourself - create a word such as
Mary's and then do a search/replace of the apostrophe by 2
apostrophes. At least in Word 2000, it creates 2 characters, and
neither of them are a grave character.
-- Thanks

On Jan 27, 6:05*pm, "Suzanne S. Barnhill" wrote:
Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org

"forever_newbie" wrote in message

...

I had a word article that I was going to insert into sql server in a text
field. *So I replaced every occurrence of apostrophe by two apostrophes
(sql
server doesn't like seeing single apostrophes in the middle of a text
field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). *When you try and replace one apostrophe by two, you get
a
reverse slanted character followed by an apostrophe. *Since I didn't
notice
this, *I went ahead and inserted the word as text into a sql field, and
now
my sql database is full of these characters. *I have to get rid of them,
so
the question is - what are they?
Thanks,


  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I get rid of strange special characters?

Possibly a grave accent? Usually on the top left key on a U.S. keyboard.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"forever_newbie" wrote in message
...
I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes
(sql
server doesn't like seeing single apostrophes in the middle of a text
field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). When you try and replace one apostrophe by two, you get
a
reverse slanted character followed by an apostrophe. Since I didn't
notice
this, I went ahead and inserted the word as text into a sql field, and
now
my sql database is full of these characters. I have to get rid of them,
so
the question is - what are they?
Thanks,




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Special characters Ron Microsoft Word Help 1 April 12th 07 11:22 AM
strange characters in document sjarrell Microsoft Word Help 2 November 7th 06 05:21 AM
special characters Deirdre Microsoft Word Help 2 March 22nd 06 03:27 AM
Special characters BILLH Microsoft Word Help 5 December 8th 05 03:32 PM
Special Characters S. Kissing Microsoft Word Help 2 August 5th 05 05:23 PM


All times are GMT +1. The time now is 06:26 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"