Re: How to dump a table into an msdos text file
From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 04/12/04
- Next message: Karen: "using results from a query as the datasource for a form"
- Previous message: dwight: "Search and Replace code"
- In reply to: Ruby Tuesday: "Re: How to dump a table into an msdos text file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 12 Apr 2004 11:22:54 -0400
NOTE: In your reply, please trim the newsgroups to only
microsoft.public.access.modulesdaovba, since that's the only one that
seems relevant.
Further comments inline ...
"Ruby Tuesday" <rubytuzdayz@yahoo.com> wrote in message
news:c5e7i4$lhei$1@ID-205437.news.uni-berlin.de
>
> The character I have problem with is fractions(1/4, 1/2, 3/4,1/8,
> 3/8, 5/8) and international character with either a backtick on top
> of e or a single quote on top of e(I guess its french).
I'm not aware of the 1/8, 3/8, 5/8 characters. What font are you using?
I think the other characters you describe are accented characters.
> How do you find out if the character is beyond the regular ASCII
> table? And how to convert it so the text can display them.
It seems that your problem is that these characters are beyond the
values ASCII values 0-127, which are pretty much standardized. To
identfy them in a string, you can use the ASC() function to check the
ASCII value of each character to see if it's over 127. For example, the
following little code procedure will display (in the Immediate Window) a
list of all such characters in a given string, and how many times they
occur.
'---- start of "air code" -----
Sub ListNonstandardCharacters(ArgText As String)
Dim alngChars(128 To 255) As Long
Dim lngI As Long
Dim intAsc As Integer
For lngI = 1 to Len(ArgText)
intAsc = Asc(Mid$(ArgText, lngI, 1))
If intAsc > 127 Then
alngChars(intAsc) = alngChars(intAsc) + 1
End If
Next lngI
For intAsc = 128 to 255
If alngChars(intAsc) > 0 Then
Debug.Print _
"Char " & Chr(intAsc) & ", ASCII " & intAsc & _
", occurs " & alngChars(intAsc) & " times"
End If
Next intAsc
End Sub
'---- end of "air code" -----
-- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
- Next message: Karen: "using results from a query as the datasource for a form"
- Previous message: dwight: "Search and Replace code"
- In reply to: Ruby Tuesday: "Re: How to dump a table into an msdos text file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
