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
tt_pattern_address_add(library call)									      tt_pattern_address_add(library call)

NAME
tt_pattern_address_add -- add a value to the address field for a pattern SYNOPSIS
#include <Tt/tt_c.h> Tt_status tt_pattern_address_add( Tt_pattern p, Tt_address d); DESCRIPTION
The tt_pattern_address_add function adds a value to the address field for the specified pattern. The p argument is a unique handle for a message pattern. This handle is returned after a tt_pattern_create(3) call has been made. The d argument specifies which pattern attributes form the address that messages will be matched against. The following values are defined: TT_HANDLER The message is addressed to a specific handler that can perform this operation with these arguments. TT_OBJECT The message is addressed to a specific object that can perform this operation with these arguments. TT_OTYPE The message is addressed to the type of object that can perform this operation with these arguments. TT_PROCEDURE The message is addressed to any process that can perform this operation with these arguments. RETURN VALUE
Upon successful completion, the tt_pattern_address_add function returns the status of the operation as one of the following Tt_status val- ues: TT_OK The operation completed successfully. TT_ERR_NOMP The ttsession(1) process is not running and the ToolTalk service cannot restart it. TT_ERR_POINTER The pointer passed does not point to an object of the correct type for this operation. SEE ALSO
Tt/tt_c.h - Tttt_c(5), tt_pattern_create(3). tt_pattern_address_add(library call)
All times are GMT -4. The time now is 10:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy