txt-file is in ANSI format or OEM Character format.
in [Programming]
|
From: Joergen Bondesen on 19 Jul 2008 08:36 Hi NG. Is it possibel, in VBA, to know if a txt-file is in ANSI format or OEM Character format. Is this possible to save a txt-file (ANSI format) to OEM Character format. -- Best regards from Joergen Bondesen
From: Joel on 19 Jul 2008 08:53 I think the only real difference is the end of the lines being a "carriage return" or "carriage return and line feed". It is pretty easy to convert a file from one to the other format. "Chip Pearson" wrote: > If you know ahead of time what the content of the file is, you can parse out > some known piece of information and look at the character codes. But if you > don't know the content of the file, I don't think you can do what you want. > > > -- > Cordially, > Chip Pearson > Microsoft Most Valuable Professional > Excel Product Group > Pearson Software Consulting, LLC > www.cpearson.com > (email on web site) > > > > > "Joergen Bondesen" <bondesen(a)cool.dk> wrote in message > news:ehZgJwZ6IHA.4596(a)TK2MSFTNGP03.phx.gbl... > > Hi NG. > > > > Is it possibel, in VBA, to know if a txt-file is in ANSI format or OEM > > Character format. > > > > Is this possible to save a txt-file (ANSI format) to OEM Character format. > > > > -- > > Best regards from > > Joergen Bondesen > > > > > > >
From: Joergen Bondesen on 20 Jul 2008 02:27 Hi Joel. Thanks for your reply. >I think the only real difference is the end of the lines being a "carriage > return" or "carriage return and line feed". That is not quite correct. In Denmark we have local letters as �, � and � and therefore I have to change from ANSI to OEM when I am using data in "old" industrial ink printers. >It is pretty easy to convert a file from one to the other format. Do you have vba code for both purpose? -- Best regards from J�rgen Bondesen "Joel" <Joel(a)discussions.microsoft.com> skrev i en meddelelse news:2D7AD605-B921-4BBD-9D1F-3179B8AA9C06(a)microsoft.com... >I think the only real difference is the end of the lines being a "carriage > return" or "carriage return and line feed". > > "Chip Pearson" wrote: > >> If you know ahead of time what the content of the file is, you can parse >> out >> some known piece of information and look at the character codes. But if >> you >> don't know the content of the file, I don't think you can do what you >> want. >> >> >> -- >> Cordially, >> Chip Pearson >> Microsoft Most Valuable Professional >> Excel Product Group >> Pearson Software Consulting, LLC >> www.cpearson.com >> (email on web site) >> >> >> >> >> "Joergen Bondesen" <bondesen(a)cool.dk> wrote in message >> news:ehZgJwZ6IHA.4596(a)TK2MSFTNGP03.phx.gbl... >> > Hi NG. >> > >> > Is it possibel, in VBA, to know if a txt-file is in ANSI format or OEM >> > Character format. >> > >> > Is this possible to save a txt-file (ANSI format) to OEM Character >> > format. >> > >> > -- >> > Best regards from >> > Joergen Bondesen >> > >> > >> > >>
From: Joel on 20 Jul 2008 06:40 Now I understand the problem. Have you saved the file as CSV file or other Text formats. What happens? to fully understand what is happening you need to save the file and then open the file with Notepad or some other text editor. Also try printing some of the text files and see what happends. The older printers have a smaller character set (number of characters) it recognizes. When you use excel or other microsoft products such as word you are using the OEM character set to be compatible with the printer. You are actually changing the Font and not the word. The font setting are invisible formatting characters just like Bold setting or color settings. when you save the file as text all the formating characters are removed. The solution in word would be to save the file as RTF which keeps the formating. You could try copying the file to word and then save the File as RTF. "Joergen Bondesen" wrote: > Hi Joel. > > Thanks for your reply. > > >I think the only real difference is the end of the lines being a "carriage > > return" or "carriage return and line feed". > That is not quite correct. In Denmark we have local letters as æ, ø and å > and therefore I have to change from ANSI to OEM when I am using data in > "old" industrial ink printers. > > >It is pretty easy to convert a file from one to the other format. > > Do you have vba code for both purpose? > > -- > Best regards from > > Jørgen Bondesen > > > "Joel" <Joel(a)discussions.microsoft.com> skrev i en meddelelse > news:2D7AD605-B921-4BBD-9D1F-3179B8AA9C06(a)microsoft.com... > >I think the only real difference is the end of the lines being a "carriage > > return" or "carriage return and line feed". > > > > "Chip Pearson" wrote: > > > >> If you know ahead of time what the content of the file is, you can parse > >> out > >> some known piece of information and look at the character codes. But if > >> you > >> don't know the content of the file, I don't think you can do what you > >> want. > >> > >> > >> -- > >> Cordially, > >> Chip Pearson > >> Microsoft Most Valuable Professional > >> Excel Product Group > >> Pearson Software Consulting, LLC > >> www.cpearson.com > >> (email on web site) > >> > >> > >> > >> > >> "Joergen Bondesen" <bondesen(a)cool.dk> wrote in message > >> news:ehZgJwZ6IHA.4596(a)TK2MSFTNGP03.phx.gbl... > >> > Hi NG. > >> > > >> > Is it possibel, in VBA, to know if a txt-file is in ANSI format or OEM > >> > Character format. > >> > > >> > Is this possible to save a txt-file (ANSI format) to OEM Character > >> > format. > >> > > >> > -- > >> > Best regards from > >> > Joergen Bondesen > >> > > >> > > >> > > >> > > >
From: Joergen Bondesen on 20 Jul 2008 16:37
Hi Joel. Thanks for reply. Regret my insufficient explanation in the beginning. Today I save the Excel file with customer data to a csv-file. This file I open in UltraEdit (Hex-editor) and change ANSI to OEM and close then file. This file I deliver to the production ink-printer. The operator then load the file into then machine. I do think it is some old "DOS" because it is not Windows. Then the operator ink customer data on magazines. It would be very nice if I could save the Excel-file as an OEM csv-file. It would also be nice if I could test a csv-file for ANSI/OEM version. -- Best regards from Joergen Bondesen "Joel" <Joel(a)discussions.microsoft.com> skrev i en meddelelse news:2A4DF68F-35A5-40AA-ACD5-4B8185AAD29A(a)microsoft.com... > Now I understand the problem. Have you saved the file as CSV file or > other > Text formats. What happens? > > to fully understand what is happening you need to save the file and then > open the file with Notepad or some other text editor. Also try printing > some > of the text files and see what happends. > > The older printers have a smaller character set (number of characters) it > recognizes. When you use excel or other microsoft products such as word > you > are using the OEM character set to be compatible with the printer. > > You are actually changing the Font and not the word. The font setting > are > invisible formatting characters just like Bold setting or color settings. > when you save the file as text all the formating characters are removed. > The solution in word would be to save the file as RTF which keeps the > formating. > > You could try copying the file to word and then save the File as RTF. > > "Joergen Bondesen" wrote: > >> Hi Joel. >> >> Thanks for your reply. >> >> >I think the only real difference is the end of the lines being a >> >"carriage >> > return" or "carriage return and line feed". >> That is not quite correct. In Denmark we have local letters as �, � and � >> and therefore I have to change from ANSI to OEM when I am using data in >> "old" industrial ink printers. >> >> >It is pretty easy to convert a file from one to the other format. >> >> Do you have vba code for both purpose? >> >> -- >> Best regards from >> >> J�rgen Bondesen >> >> >> "Joel" <Joel(a)discussions.microsoft.com> skrev i en meddelelse >> news:2D7AD605-B921-4BBD-9D1F-3179B8AA9C06(a)microsoft.com... >> >I think the only real difference is the end of the lines being a >> >"carriage >> > return" or "carriage return and line feed". >> > >> > "Chip Pearson" wrote: >> > >> >> If you know ahead of time what the content of the file is, you can >> >> parse >> >> out >> >> some known piece of information and look at the character codes. But >> >> if >> >> you >> >> don't know the content of the file, I don't think you can do what you >> >> want. >> >> >> >> >> >> -- >> >> Cordially, >> >> Chip Pearson >> >> Microsoft Most Valuable Professional >> >> Excel Product Group >> >> Pearson Software Consulting, LLC >> >> www.cpearson.com >> >> (email on web site) >> >> >> >> >> >> >> >> >> >> "Joergen Bondesen" <bondesen(a)cool.dk> wrote in message >> >> news:ehZgJwZ6IHA.4596(a)TK2MSFTNGP03.phx.gbl... >> >> > Hi NG. >> >> > >> >> > Is it possibel, in VBA, to know if a txt-file is in ANSI format or >> >> > OEM >> >> > Character format. >> >> > >> >> > Is this possible to save a txt-file (ANSI format) to OEM Character >> >> > format. >> >> > >> >> > -- >> >> > Best regards from >> >> > Joergen Bondesen >> >> > >> >> > >> >> > >> >> >> >> >> |