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
Posted by: JohnV@msn.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (13) |
Tidak ada komentar:
Posting Komentar