Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Editing my data file

  1. May 6, 2009 #1

    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!
  2. jcsd
  3. May 6, 2009 #2


    User Avatar
    Science Advisor
    Homework Helper

    Look at awk (eg http://student.northpark.edu/pemente/awk/awk1line.txt [Broken]) it's a very simple language for text processing

    Print column 1 - column 2 would be something like:
    awk '{print $1-$2}' datafile.txt
    Last edited by a moderator: May 4, 2017
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook