ACCESS FEED: RE: [MS_AccessPros] Convert comma delimiter to cedilla delimiter

Kamis, 26 Februari 2015

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 ...
			View on en.wikipedia.org	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

http://www.viescas.com/

(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