Sponsored Content
Top Forums Shell Programming and Scripting perform some operation on a specific coulmn starting from a specific line Post 302444277 by shashi792 on Wednesday 11th of August 2010 11:31:50 AM
Old 08-11-2010
Data perform some operation on a specific coulmn starting from a specific line

I have a txt file having rows and coulmns, i want to perform some operation on a specific coulmn starting from a specific line.

eg:
Code:
 50.000000               1           1           1
  1000.00000    
  1000.00000    
   50000.000    
     19
     19
  3.69797533E-07   871.66394       36.611320      -12.000000      -35.290180          4      5
  1.13238150E-06   879.03741       36.047676      -10.800000       38.395638          4      4
  6.69133044E-07   717.85254       34.777313      -9.1999998       24.722189          3      3
  8.59679221E-06   381.38339       33.485676      -8.0000000       14.840780          1      1
  5.23395693E-06   247.83061       33.334003      -5.5999999      -5.1661811          0      1
  6.89546050E-06   259.99509       33.329212      -5.1999998      -6.1069846          0      1

I want to select the data from 3rd coulmn from 7th line to end of clm. And find out the minimum and the maximum out of them.

my idea (but do not knw hw to proceed)
1 : mv the txt file to a csv file and then copy only the required column from a specified row to txt file and then perform operation to find (min / max)

how do i proceed with this problem.

Moderator's Comments:
Mod Comment Use code tags please, ty.

Last edited by zaxxon; 08-11-2010 at 12:42 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perform a set of actions for a specific file type

Hello, I have a problem that I'm having quite a bit of trouble with. I am trying to create a script that performs a specific sequence of actions for a file of a specific type. This is an abbreviated version of my basic script: #!/bin/sh #coulombic calculations... (2 Replies)
Discussion started by: oehtus
2 Replies

2. UNIX for Advanced & Expert Users

How to perform Grep on many Gzip files, Searching for Specific information

Hello, I am wondering if you can assist with my question and ask kindly for this. I have a number of files that are listed as file1.gz through file100.gz. I am trying to perform a grep on the files and find a specific date that only resides within within one of the files. There are... (3 Replies)
Discussion started by: legharb
3 Replies

3. Shell Programming and Scripting

replace value with double quotes of specific coulmn value in csv file

Hi, I am trying to replace a specific column values in a csv file with double quotes. Example: SNO,NAME,ZIPCODE,RANK 1,Robert,74538,12 2,Sam,07564,13 3,Kim, Ed,12345,14 Desired Output: SNO,NAME,ZIPCODE,RANK 1,Robert Ken,74538,12 2,Sam Mik,"07564",13 3,"Kim, Ed",12345,14 I... (3 Replies)
Discussion started by: techmoris
3 Replies

4. Shell Programming and Scripting

using sed to replace a specific string on a specific line number using variables

using sed to replace a specific string on a specific line number using variables this is where i am at grep -v WARNING output | grep -v spawn | grep -v Passphrase | grep -v Authentication | grep -v '/sbin/tfadmin netguard -C'| grep -v 'NETWORK>' >> output.clean grep -n Destination... (2 Replies)
Discussion started by: todd.cutting
2 Replies

5. Shell Programming and Scripting

Using awk to read a specific line and a specific field on that line.

Say the input was as follows: Brat 20 x 1000 32rf Pour 15 p 1621 05pr Dart 10 z 1111 22xx My program prompts for an input, what I want is to use the input to locate a specific field. Like if I type in, "Pou" then it would return "Pour" and just "Pour" I currently have this line but it is... (6 Replies)
Discussion started by: Bungkai
6 Replies

6. Shell Programming and Scripting

Replace specific field on specific line sed or awk

I'm trying to update a text file via sed/awk, after a lot of searching I still can't find a code snippet that I can get to work. Brief overview: I have user input a line to a variable, I then find a specific value in this line 10th field in this case. After asking for new input and doing some... (14 Replies)
Discussion started by: crownedzero
14 Replies

7. Shell Programming and Scripting

perform actions at specific locations in data frame

Hi everyone, I got a data frame like the one below and and would like to do the following: Ignore the first 3 rows and check in all following rows the second position. If the value is >500, subtract 100. Example DF: ABC 22 DE 12 BCD 223 GH 12 EFG 2104 DH ... (4 Replies)
Discussion started by: TuAd
4 Replies

8. Shell Programming and Scripting

Extract specific line in an html file starting and ending with specific pattern to a text file

Hi This is my first post and I'm just a beginner. So please be nice to me. I have a couple of html files where a pattern beginning with "http://www.site.com" and ending with "/resource.dat" is present on every 241st line. How do I extract this to a new text file? I have tried sed -n 241,241p... (13 Replies)
Discussion started by: dejavo
13 Replies

9. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

10. Shell Programming and Scripting

Count specific character of a file in each line and delete this character in a specific position

I will appreciate if you help me here in this script in Solaris Enviroment. Scenario: i have 2 files : 1) /tmp/TRANSACTIONS_DAILY_20180730.txt: 201807300000000004 201807300000000005 201807300000000006 201807300000000007 201807300000000008 2)... (10 Replies)
Discussion started by: teokon90
10 Replies
INPUT(5)							File Formats Manual							  INPUT(5)

NAME
input - input data file format DESCRIPTION
This manual page describes the output format of the file created by the Yagi-Uda project input or first programs. The file is an ASCII file, so can be edited manually if required. It is read by yagi or optimise. The program optimise also creates the same file format. NOTES FREQUENCY MIN_FREQUENCY MAX_FREQUENCY STEP_FREQUENCY ELEMENTS DRIVEN PARASITIC ANGULAR_STEP DATA_DRIVEN DATA_PARASITIC The # is used as a comment. A typical file, for an antenna designed for the 2m amateur band (144-146 MHz) might be as shown below. Note: 1) Reflector is at position 0.0 2) All elements lengths/positions are in m. NOTES This line can be up to 400 characters. FREQUENCY 145.000000 MIN_FREQUENCY 144.000000 MAX_FREQUENCY 146.000000 STEP_FREQUENCY 0.100000 ELEMENTS 10 DRIVEN 1 PARASITIC 9 ANGULAR_STEP 180.000000 #DATA_DRIVEN x y length diameter voltage phase DATA_DRIVEN 0.30993 0.000000 1.002492 0.0063000000000000 1.000000 0.000000 # DATA_PARASITIC x y length diameter DATA_PARASITIC 0.00000 0.00000 1.01902 0.00630 0.49859 0.00000 0.95551 0.00630 1.07338 0.00000 0.93595 0.00630 1.81020 0.00000 0.92050 0.00630 2.58152 0.00000 0.91322 0.00630 3.30390 0.00000 0.91243 0.00630 4.03692 0.00000 0.90423 0.00630 4.64108 0.00000 0.89081 0.00630 5.37418 0.00000 0.83912 0.00630 FILES
filename ASCII description of antenna. filename.out binary file SEE ALSO
yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5). AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov). Yagi version 1.16 24th October 2000 INPUT(5)
All times are GMT -4. The time now is 11:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy