# Editing my data file

by omegacore
Tags: data editing, linux
 P: 15 Hello! I am running ubuntu, I have a copy of open office excel, but I need to edit a tab space delimited text file with my data in it so I can use gnuplot to plot it. The editing consists of subtracting one column of data from a file, from another column of data in another file. Each row corresponds to another row in another document... There are about 1000 rows so I cannot do this manually. My lab writeup is due in a few hours, this is the last step I need to complete for the analysis! I know there is a way to write a quick and dirty program that will perform the operation, but my experience with such things is limited to date. So please! Help!
 Sci Advisor HW Helper P: 8,961 Look at awk (eg http://student.northpark.edu/pemente/awk/awk1line.txt) it's a very simple language for text processing Print column 1 - column 2 would be something like: awk '{print $1-$2}' datafile.txt

 Related Discussions Math & Science Software 2 Math & Science Software 3 Engineering, Comp Sci, & Technology Homework 1 Math & Science Software 4 Computing & Technology 3