That and I learned that it was used on other letters in different languages! Cool stuff.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 26, 2015 10:25 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Convert comma delimiter to cedilla delimiter
Hi John
Thanks for that! A fascinating article for a linguaphile like me!
@Mike: It appears that both Liz and I were wrong – the cedilla does exist by itself as an ANSI character (¸). Use Chr(184).
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, 27 February 2015 00:03
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Convert comma delimiter to cedilla delimiter
Ç is the most common. Interesting article on Wiki:
Cedilla - Wikipedia, the free encyclopedia
| | Cedilla - Wikipedia, the free encyclopedia A cedilla (/sɨˈdɪlə/ si-DIL-ə; from Spanish), also known as cedilha (from Portuguese) or cédille (from French), is a hook or tail ( ¸ ) added under certain letters ... | ||||
| Preview by Yahoo | |||||
The article also lists the hex codes for the letters.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
---In MS_Access_Professionals@yahoogroups.com, <graham@mandeno.com> wrote :
Hi Mike
Just to clarify, the character I think you are talking about is a "C with a cedilla". The cedilla is the small accent (diacritical mark) that looks like a "5" without the horizontal bar, which you see below the "C". As Liz says, that does not exist as a character on its own. The cedilla can be attached to a lowercase "c" (ç) or an uppercase "C" (Ç) – there is no such thing as an "uppercase cedilla".
The ANSI code for a "lowercase c with cedilla" is 231, so you can get the character with Chr(231):
strText = Replace(strText, ",", Chr(231))
will replace every comma in the string with that character.
The character code for the "uppercase C with cedilla" is 199, so substitute 199 for 231 and you will have it.
One way to discover character codes is to open Word (any document), select the Insert ribbon, and click Symbol > More symbols… > Symbols tab. Set the font to "(normal text)" and scroll down until you see the accented characters. Clicking on a character will display its numeric code in the "Character code" box.
Good luck!
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
Sent: Thursday, 26 February 2015 09:28
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Convert comma delimiter to cedilla delimiter
John, thanks so much! How do I get the upper case cedilla? Can you reply with that one?
Thanks again!
Mike
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar