txt-file is in ANSI format or OEM Character format.
in [Programming]
|
From: Joel on 20 Jul 2008 18:01 I think there is a simplier solution. Any of the option below can be converted to a macro if it works. 1) Try saving the file as formatted Text space Delimited. 2) Try printing to a "file" using a OEM Printer or other printer 3) Try copying data to word. Then in word Print to a "file" using different Printers. 4) Try 2 and 3 above changing formating to a different Font. You really have a font problem. You need to get the correct Font that will work with the printer you are using. I can fix any spacing problems you may have with a macro, we just need to get the characters in the file to be correct. Another solution if UltraEdit (Hex-editor) supports a scripting language is to automatically start the Ultraeditor from excel so the conversion is automatic. "Joergen Bondesen" wrote: > 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 > >> >> > > >> >> > > >> >> > > >> >> > >> > >> > >> > > >
From: Joergen Bondesen on 21 Jul 2008 15:21
Hi Joel. > Another solution if UltraEdit (Hex-editor) supports a scripting language > is > to automatically start the Ultraeditor from excel so the conversion is > automatic. I will try this solution. Thanks for your time. Perhaps, I will be back, later. -- Best Regards from Joergen Bondesen "Joel" <Joel(a)discussions.microsoft.com> skrev i en meddelelse news:D36F8C44-D3D4-4B79-AA40-85EF1C92043E(a)microsoft.com... >I think there is a simplier solution. Any of the option below can be > converted to a macro if it works. > > 1) Try saving the file as formatted Text space Delimited. > 2) Try printing to a "file" using a OEM Printer or other printer > 3) Try copying data to word. Then in word Print to a "file" using > different > Printers. > 4) Try 2 and 3 above changing formating to a different Font. > > You really have a font problem. You need to get the correct Font that will > work with the printer you are using. I can fix any spacing problems you > may > have with a macro, we just need to get the characters in the file to be > correct. > > Another solution if UltraEdit (Hex-editor) supports a scripting language > is > to automatically start the Ultraeditor from excel so the conversion is > automatic. > > "Joergen Bondesen" wrote: > >> 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 >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> |