[Dclug] [Ma-linux] Gnumeric Help Sought(a bit OT)
Kevin Cole
dc.loco at gmail.com
Thu Nov 4 19:03:14 EDT 2010
Hi,
If you already have two files with "999,999" you can use the paste
application (part of the coreutils package under Ubuntu).
$ paste a b > c.csv
goes line-by-line takeing a line from file "a" followed by a <TAB>
followed by the corresponding line from file "b", and you direct the
output to file "c.csv".
Now, in Gnumeric, use Data -> Get External Data -> Import Text File...
Feed it c.csv and tell it that the "Original data type" is "Separated"
as opposed to "Fixed width" and click "Forward". Tell it that the
"Separator" is a "Tab". "Forward" again, and see if things look
approximately right. Then "Finish".
--
Ubuntu Linux DC LoCo
Washington, DC
http://dc.ubuntu-us.org/
More information about the Dclug
mailing list