[SLE] OT data control of MSWORD & MS EXcel under linux
Hi everyone, Well could be of topic what I will be asking ( just let me know if it is) I have two files file 1 is created with MSword in a table format and has 200 names in it file 2 is created with MS Excel and rougly has =>200 names in it What I have to do is to check if the both files have the same name sin them and find the ones which are different The question is as follows is there a conversion utility to convert these to identical formats and possibly run a grep (?) command piping the output to a file for the differences. Or am I completely in wrong direction Thx -- Togan Muftuoglu toganm@turk.net -- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/
On Sat, 17 Jun 2000, Togan Muftuoglu wrote:
<-]Date: Sat, 17 Jun 2000 00:30:47 +0300
<-]From: Togan Muftuoglu
Nicolas Beaulieu wrote:
<-] <-]The question is as follows is there a conversion utility to convert <-]these to identical formats and possibly run a grep (?) command piping <-]the output to a file for the differences. <-] <-]Or am I completely in wrong direction
You're not. Indeed, it is possible to achieve this task using converters: catdoc for MS-Word format and the other, xls2csv for MS-Excel format.
There seems to be a new version of mswordview at http://www.wvware.com It also has an online check section which read my word file correctly. I thought while downloading the library should also give an update on the conversion utilities. Thanks for the guidance Nicolas -- Togan Muftuoglu toganm@turk.net -- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/
Togan Muftuoglu wrote:
Hi everyone,
Well could be of topic what I will be asking ( just let me know if it is)
I have two files
file 1 is created with MSword in a table format and has 200 names in it file 2 is created with MS Excel and rougly has =>200 names in it
What I have to do is to check if the both files have the same name sin them and find the ones which are different
The question is as follows is there a conversion utility to convert these to identical formats and possibly run a grep (?) command piping the output to a file for the differences.
Or am I completely in wrong direction
Thx
Hi Togan, sounds like an interesting job for long winter nights. ;-) Just read Nicolas post on it, didn't know that rools like xls2csv exist. I am a bit uncertain on this converting, due to Character sets, extra spaces in data fields etc. But thats a matter of trial and error. I would import the stuff into SO and konvert it into the spreadsheet and start from there. Recently, I did a similar job at work -comparing two lists, and on finding the entry in the main list I added some data from list2 to it- I did that in Excel VBA, since I cannot use proper tools at work (in a double sense... ;-)) Juergen -- =========================================== __ _ Juergen Braukmann juergen.braukmann@gmx.de| -o)/ / (_)__ __ ____ __ Tel: 0201-743648 dk4jb@db0qs.#nrw.deu.eu | /\\ /__/ / _ \/ // /\ \/ / ===========================================_\_v __/_/_//_/\_,_/ /_/\_\ -- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/
juergen.braukmann@ruhr-west.de wrote:
Hi Togan, sounds like an interesting job for long winter nights. ;-) Just read Nicolas post on it, didn't know that rools like xls2csv exist. I am a bit uncertain on this converting, due to Character sets, extra spaces in data fields etc. But thats a matter of trial and error. I would import the stuff into SO and konvert it into the spreadsheet and start from there. Recently, I did a similar job at work -comparing two lists, and on finding the entry in the main list I added some data from list2 to it- I did that in Excel VBA, since I cannot use proper tools at work (in a double sense... ;-))
Well I had the first intention to get it imported to So however SO does not recognize Turkish character sets. So I end up having either ?? marks or the characters are chopped of. I normally use Applix 4.4.2 althogh I can import MS office documents with no problem this time it does not work for the following reasons These two files were created by my wife under Windows SE international with PAN europen character set. There are two different Turkish character sets used by windows either Windows CP 1254 or Windows ISO Turkish. They are both different and I guess these were created with CP 1254. This causes the applixware problem. Therefore SO and Applixware could be the ending products but I need to get the files converted to somehow meaningfull format. I read catdoc man and looks interesting (It was in the Suse CD's good job Suse)I need to read more and understand how to find a way to convert to different charsets. yes I agree could be an intersting long winter project but as usual I needed it yesterday. Thanks BTW if you can think oother alternatives please feel free to drop personal email -- Togan Muftuoglu toganm@turk.net -- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/
participants (3)
-
juergen.braukmann@ruhr-west.de
-
nbea@ecn.ulaval.ca
-
toganm@turk.net