Prev: How to read from USB port?
Next: May have hosed my registry
From: Tony Proctor on 5 Dec 2006 08:06
Sounds like you need to confirm that it really is in UTF-8 first. Notepad
supports UTF-8 (check the Encoding box in the SaveAs dialog). If this box is
set to UTF-8, and Notepad displays the data correctly, maybe you could
provide us with a piece of your data. I'll then test it here

Tony Proctor

"MSK" <mannaikarthik(a)yahoo.com> wrote in message
news:1165320647.097850.94510(a)l12g2000cwl.googlegroups.com...
> I have lot of data in a text file (like address, department name...etc)
> , these details contains "Welsh" chars (UK)
> (a,e,i,o,u,y,w,A,E,I,O,U,Y,W with circumflex), I want to open and read
> this file and fill the controls (combobox, listbox),
> I have saved the file as Unicode and I tried UTF-8 format too. Hope
> this gives more input...give me some logic so that I can try...like
> inputB, strConv...I tried everything but I am getting some junk chars
>
> once again Thanks
>
> MSK.
>
> On Dec 5, 11:54 am, "Tony Proctor"
> <tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> > VB uses Unicode internally. Hence, you have to convert the UTF-8 to
Unicode
> > when loading it into the VB app. Controls generally use the current ANSI
> > code page rather than Unicode but the translation from Unicode will
happen
> > transparently - you don't have to do it yourself. If the characters are
not
> > appearing then it may be that those characters are not part of your
current
> > ANSI code page. What locale are you using, and what characters are you
> > trying to display?
> >
> > Tony Proctor
> >
> > "MSK" <mannaikart...(a)yahoo.com> wrote in
messagenews:1165318371.806846.303470(a)j44g2000cwa.googlegroups.com...>
Thanks, but that code converts the UTF-8 chars into Unicode,again I am
> > > losing the required chars, actually I want to show those special chars
> > > as it is in the list box.
> >
> > > MSK.
> >
> > > Tony Proctor wrote:
> > > > Here's a link to some code that reads UTF-8 encoded data into a VB
app:http://groups.google.ie/group/microsoft.public.vb.general.discussion/...
> >
> >
> >
> >
> >
> > > > Tony Proctor
> >
> > > > "MSK" <mannaikart...(a)yahoo.com> wrote in message
> > > >news:1165312983.479419.100970(a)73g2000cwn.googlegroups.com...
> > > > > Hi,
> >
> > > > > I am currently developing some Word templates (office 2003) + VBA
> >
> > > > > I have a UTF-8 encoded text file...I wanted to read and show the
> > > > > values into a list box...
> >
> > > > > The charactors are getting changed while reading and filling the
> > > > > control...(but in the text file they are perfect)
> >
> > > > > I tried FSO and Open statement with Line input.. I dont know how
to
> > > > > Convert into normal chars..
> >
> > > > > How to resovle.. ?
> >
> > > > > Its bit urgent...give me some useful links
> >
> > > > > Many thanks.
> > > > > MSK.- Hide quoted text -- Show quoted text -
>


From: MSK on 5 Dec 2006 08:53
Thank you very much for your support.

See the sample text below, Save the followoing into a text file (save
as Unicode or UTF-8 format)

TÅ· Ladywell
TÅ· Dewi Sant
Plas Glyndŵr
Dod â’ch busnes i Gymru
bêl-droed

I want to show these values in a combo box in MS Office 2003 word
templates (VBA ), User will selecte the required values from the
combobox and then (after 4-5 GUI user inputs) the selected text ( and
given other input) should be placed in the word document.

MSK.





On Dec 5, 1:06 pm, "Tony Proctor"
<tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> Sounds like you need to confirm that it really is in UTF-8 first. Notepad
> supports UTF-8 (check the Encoding box in the SaveAs dialog). If this box is
> set to UTF-8, and Notepad displays the data correctly, maybe you could
> provide us with a piece of your data. I'll then test it here
>
>     Tony Proctor
>
> "MSK" <mannaikart...(a)yahoo.com> wrote in messagenews:1165320647.097850.94510(a)l12g2000cwl.googlegroups.com...
>
>
>
> > I have lot of data in a text file (like address, department name...etc)
> > , these details contains "Welsh" chars (UK)
> > (a,e,i,o,u,y,w,A,E,I,O,U,Y,W  with circumflex), I want to open and read
> > this file and fill the controls (combobox, listbox),
> > I have saved the file as Unicode  and I tried UTF-8 format too. Hope
> > this gives more input...give me some logic so that I can try...like
> > inputB, strConv...I tried everything  but I am getting some junk chars
>
> > once again Thanks
>
> > MSK.
>
> > On Dec 5, 11:54 am, "Tony Proctor"
> > <tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> > > VB uses Unicode internally. Hence, you have to convert the UTF-8 to
> Unicode
> > > when loading it into the VB app. Controls generally use the current ANSI
> > > code page rather than Unicode but the translation from Unicode will
> happen
> > > transparently - you don't have to do it yourself. If the characters are
> not
> > > appearing then it may be that those characters are not part of your
> current
> > > ANSI code page. What locale are you using, and what characters are you
> > > trying to display?
>
> > >     Tony Proctor
>
> > > "MSK" <mannaikart...(a)yahoo.com> wrote inmessagenews:1165318371.806846..303470(a)j44g2000cwa.googlegroups.com...>
> Thanks, but that code converts the UTF-8 chars into Unicode,again I am> > > losing the required chars, actually I want to show those special chars
> > > > as it is in the list box.
>
> > > > MSK.
>
> > > > Tony Proctor wrote:
> > > > > Here's a link to some code that reads UTF-8 encoded data into a VBapp:http://groups.google.ie/group/microsoft.public.vb.general.discussion/....
>
>
>
>
>
> > > > >     Tony Proctor
>
> > > > > "MSK" <mannaikart...(a)yahoo.com> wrote in message
> > > > >news:1165312983.479419.100970(a)73g2000cwn.googlegroups.com...
> > > > > > Hi,
>
> > > > > > I am currently developing some Word templates (office 2003) + VBA
>
> > > > > > I have  a UTF-8 encoded text file...I wanted to read and show the
> > > > > > values into a list box...
>
> > > > > > The charactors are getting changed while reading and filling the
> > > > > > control...(but in the text file they are perfect)
>
> > > > > > I tried FSO and Open statement with Line input.. I dont know how
> to
> > > > > > Convert into normal chars..
>
> > > > > > How to resovle.. ?
>
> > > > > > Its bit urgent...give me some useful links
>
> > > > > > Many thanks.
> > > > > > MSK.- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

From: Tony Proctor on 5 Dec 2006 09:16
Not all of these characters are in the Latin-1 code page (1252). For
instance, you can display the a-/e-circumflex, but not the y-/w-circumflex.
Is that what you're missing there

Tony Proctor

"MSK" <mannaikarthik(a)yahoo.com> wrote in message
news:1165326824.577200.28490(a)73g2000cwn.googlegroups.com...
Thank you very much for your support.

See the sample text below, Save the followoing into a text file (save
as Unicode or UTF-8 format)

Ty Ladywell
Ty Dewi Sant
Plas Glyndwr
Dod �'ch busnes i Gymru
b�l-droed

I want to show these values in a combo box in MS Office 2003 word
templates (VBA ), User will selecte the required values from the
combobox and then (after 4-5 GUI user inputs) the selected text ( and
given other input) should be placed in the word document.

MSK.





On Dec 5, 1:06 pm, "Tony Proctor"
<tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> Sounds like you need to confirm that it really is in UTF-8 first. Notepad
> supports UTF-8 (check the Encoding box in the SaveAs dialog). If this box
is
> set to UTF-8, and Notepad displays the data correctly, maybe you could
> provide us with a piece of your data. I'll then test it here
>
> Tony Proctor
>
> "MSK" <mannaikart...(a)yahoo.com> wrote in
messagenews:1165320647.097850.94510(a)l12g2000cwl.googlegroups.com...
>
>
>
> > I have lot of data in a text file (like address, department name...etc)
> > , these details contains "Welsh" chars (UK)
> > (a,e,i,o,u,y,w,A,E,I,O,U,Y,W with circumflex), I want to open and read
> > this file and fill the controls (combobox, listbox),
> > I have saved the file as Unicode and I tried UTF-8 format too. Hope
> > this gives more input...give me some logic so that I can try...like
> > inputB, strConv...I tried everything but I am getting some junk chars
>
> > once again Thanks
>
> > MSK.
>
> > On Dec 5, 11:54 am, "Tony Proctor"
> > <tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> > > VB uses Unicode internally. Hence, you have to convert the UTF-8 to
> Unicode
> > > when loading it into the VB app. Controls generally use the current
ANSI
> > > code page rather than Unicode but the translation from Unicode will
> happen
> > > transparently - you don't have to do it yourself. If the characters
are
> not
> > > appearing then it may be that those characters are not part of your
> current
> > > ANSI code page. What locale are you using, and what characters are you
> > > trying to display?
>
> > > Tony Proctor
>
> > > "MSK" <mannaikart...(a)yahoo.com> wrote
inmessagenews:1165318371.806846.303470(a)j44g2000cwa.googlegroups.com...>
> Thanks, but that code converts the UTF-8 chars into Unicode,again I am> >
> losing the required chars, actually I want to show those special chars
> > > > as it is in the list box.
>
> > > > MSK.
>
> > > > Tony Proctor wrote:
> > > > > Here's a link to some code that reads UTF-8 encoded data into a
VBapp:http://groups.google.ie/group/microsoft.public.vb.general.discussion/.
...
>
>
>
>
>
> > > > > Tony Proctor
>
> > > > > "MSK" <mannaikart...(a)yahoo.com> wrote in message
> > > > >news:1165312983.479419.100970(a)73g2000cwn.googlegroups.com...
> > > > > > Hi,
>
> > > > > > I am currently developing some Word templates (office 2003) +
VBA
>
> > > > > > I have a UTF-8 encoded text file...I wanted to read and show the
> > > > > > values into a list box...
>
> > > > > > The charactors are getting changed while reading and filling the
> > > > > > control...(but in the text file they are perfect)
>
> > > > > > I tried FSO and Open statement with Line input.. I dont know how
> to
> > > > > > Convert into normal chars..
>
> > > > > > How to resovle.. ?
>
> > > > > > Its bit urgent...give me some useful links
>
> > > > > > Many thanks.
> > > > > > MSK.- Hide quoted text -- Show quoted text -- Hide quoted
text -- Show quoted text -- Hide quoted text -- Show quoted text -


From: Tony Proctor on 5 Dec 2006 09:25
The consensus seems to be that Latin-1 copes with Welsh. However, have a
read of this:
https://listserv.heanet.ie/cgi-bin/wa?A2=ind9302&L=welsh-l&D=0&T=0&P=1337

Tony Proctor

"MSK" <mannaikarthik(a)yahoo.com> wrote in message
news:1165326824.577200.28490(a)73g2000cwn.googlegroups.com...
Thank you very much for your support.

See the sample text below, Save the followoing into a text file (save
as Unicode or UTF-8 format)

Ty Ladywell
Ty Dewi Sant
Plas Glyndwr
Dod �'ch busnes i Gymru
b�l-droed

I want to show these values in a combo box in MS Office 2003 word
templates (VBA ), User will selecte the required values from the
combobox and then (after 4-5 GUI user inputs) the selected text ( and
given other input) should be placed in the word document.

MSK.





On Dec 5, 1:06 pm, "Tony Proctor"
<tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> Sounds like you need to confirm that it really is in UTF-8 first. Notepad
> supports UTF-8 (check the Encoding box in the SaveAs dialog). If this box
is
> set to UTF-8, and Notepad displays the data correctly, maybe you could
> provide us with a piece of your data. I'll then test it here
>
> Tony Proctor
>
> "MSK" <mannaikart...(a)yahoo.com> wrote in
messagenews:1165320647.097850.94510(a)l12g2000cwl.googlegroups.com...
>
>
>
> > I have lot of data in a text file (like address, department name...etc)
> > , these details contains "Welsh" chars (UK)
> > (a,e,i,o,u,y,w,A,E,I,O,U,Y,W with circumflex), I want to open and read
> > this file and fill the controls (combobox, listbox),
> > I have saved the file as Unicode and I tried UTF-8 format too. Hope
> > this gives more input...give me some logic so that I can try...like
> > inputB, strConv...I tried everything but I am getting some junk chars
>
> > once again Thanks
>
> > MSK.
>
> > On Dec 5, 11:54 am, "Tony Proctor"
> > <tony_proctor(a)aimtechnology_NoMoreSPAM_.com> wrote:
> > > VB uses Unicode internally. Hence, you have to convert the UTF-8 to
> Unicode
> > > when loading it into the VB app. Controls generally use the current
ANSI
> > > code page rather than Unicode but the translation from Unicode will
> happen
> > > transparently - you don't have to do it yourself. If the characters
are
> not
> > > appearing then it may be that those characters are not part of your
> current
> > > ANSI code page. What locale are you using, and what characters are you
> > > trying to display?
>
> > > Tony Proctor
>
> > > "MSK" <mannaikart...(a)yahoo.com> wrote
inmessagenews:1165318371.806846.303470(a)j44g2000cwa.googlegroups.com...>
> Thanks, but that code converts the UTF-8 chars into Unicode,again I am> >
> losing the required chars, actually I want to show those special chars
> > > > as it is in the list box.
>
> > > > MSK.
>
> > > > Tony Proctor wrote:
> > > > > Here's a link to some code that reads UTF-8 encoded data into a
VBapp:http://groups.google.ie/group/microsoft.public.vb.general.discussion/.
...
>
>
>
>
>
> > > > > Tony Proctor
>
> > > > > "MSK" <mannaikart...(a)yahoo.com> wrote in message
> > > > >news:1165312983.479419.100970(a)73g2000cwn.googlegroups.com...
> > > > > > Hi,
>
> > > > > > I am currently developing some Word templates (office 2003) +
VBA
>
> > > > > > I have a UTF-8 encoded text file...I wanted to read and show the
> > > > > > values into a list box...
>
> > > > > > The charactors are getting changed while reading and filling the
> > > > > > control...(but in the text file they are perfect)
>
> > > > > > I tried FSO and Open statement with Line input.. I dont know how
> to
> > > > > > Convert into normal chars..
>
> > > > > > How to resovle.. ?
>
> > > > > > Its bit urgent...give me some useful links
>
> > > > > > Many thanks.
> > > > > > MSK.- Hide quoted text -- Show quoted text -- Hide quoted
text -- Show quoted text -- Hide quoted text -- Show quoted text -


From: MSK on 5 Dec 2006 09:59
Yes, you are correct...

if I save the file in Unicode format - " â, ê " chars are coming
fine but ŵ , ŷ are tured as junk chars.
In the given example (Dod â'ch busnes i Gymru) - in this line " â
" is appearing fine but the next char " ' " is appearing like a
square/box.

If I save the file as UTF-8 format ....all the chars are messed up.

just tell me is it possible with VBA or not...atleast I can update my
manager.

MSK.

First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: How to read from USB port?
Next: May have hosed my registry