Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Filtering first file columns based on second file column
Top Forums Shell Programming and Scripting Filtering first file columns based on second file column Post 302715757 by joeyg on Monday 15th of October 2012 10:48:25 AM
Old 10-15-2012
Not sure what you have tried...
The following will help find the column to be excluded:

Code:
$ echo sn,data1,data2 | tr "," "\n" | cat
sn
data1
data2

$ echo sn,data1,data2 | tr "," "\n" | cat -n
     1  sn
     2  data1
     3  data2

$ echo sn,data1,data2 | tr "," "\n" | cat -n | grep "data1"
     2  data1

$ echo sn,data1,data2 | tr "," "\n" | cat -n | grep "data1" | cut -f1
     2

Now, to exclude a column, you can see if your 'cut' command recognizes the --complement option. Something like:
Code:
cut -f2 -- complement sample1.txt

Or...
Code:
 awk '{$2=""; print}' sample1.txt

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Filtering records of a file based on a value of a column

Hi all, I would like to extract records of a file based on a condition. The file contains 47 fields, and I would like to extract only those records that match a certain value in one of the columns, e.g. COL1 COL2 COL3 ............... COL47 1 XX 45 ... (4 Replies)
Discussion started by: risk_sly
4 Replies

2. Shell Programming and Scripting

filtering one file based on results from other

Can anybody help me with writing a script for the data that I want to use from one file based on the data from another file. I have file1 in this form; (the first field represents a well name and the second field represents the depth of interest) FILE1 -------- DATA_35_0 ... (2 Replies)
Discussion started by: digipak
2 Replies

3. Shell Programming and Scripting

filtering one file based on results from other- AGAIN

I have asked this question here before and got the answer too. Unfortunately I used only one record as an example and the script works fine for one record but not for more than one record. Can anybody help me with writing a script for the data that I want to use from one file based on the... (13 Replies)
Discussion started by: digipak
13 Replies

4. Shell Programming and Scripting

Filtering issues with multiple columns in a single file

Hi, I am new to unix and would greatly appreciate some help. I have a file containing multiple colums containing different sets of data e.g. File 1: John Ireland 27_December_69 Mary England 13_March_55 Mike France 02_June_80 I am currently using the awk... (10 Replies)
Discussion started by: crunchie
10 Replies

5. UNIX for Dummies Questions & Answers

Filtering records from 1 file based on some manipulation doen on second file

Hi, I am looking for an awk script which should help me to meet the following requirement: File1 has records in following format INF: FAILEd RECORD AB1234 INF: FAILEd RECORD PQ1145 INF: FAILEd RECORD AB3215 INF: FAILEd RECORD AB6114 ............................ (2 Replies)
Discussion started by: mintu41
2 Replies

6. Shell Programming and Scripting

Filtering lines for column elements based on corresponding counts in another column

Hi, I have a file like this ACC 2 2 21 aaa AC 443 3 22 aaa GCT 76 1 33 xxx TCG 34 2 33 aaa ACGT 33 1 22 ggg TTC 99 3 44 wee CCA 33 2 33 ggg AAC 1 3 55 ddd TTG 10 1 22 ddd TTGC 98 3 22 ddd GCT 23 1 21 sds GTC 23 4 32 sds ACGT 32 2 33 vvv CGT 11 2 33 eee CCC 87 2 44... (1 Reply)
Discussion started by: polsum
1 Replies

7. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies

8. Shell Programming and Scripting

Replacing 12 columns of one file by second file based on mapping in third file

i have a real data prod file with 80+ fields containing 1k -2k records. i have to extract say 12 columns out of this which are sensitive fields along with one primary key say SEQ_ID (like DOB,account no, name, SEQ_ID, govtid etc) in a lookup file. i have to replace these sensitive fields in... (11 Replies)
Discussion started by: megh12
11 Replies

9. UNIX for Beginners Questions & Answers

Filtering based on column values

Hi there, I am trying to filter a big file with several columns using values on a column with values like (AC=5;AN=10;SF=341,377,517,643,662;VRT=1). I wont to filter the data based on SF= values that are (bigger than 400) ... (25 Replies)
Discussion started by: daashti
25 Replies

10. UNIX for Beginners Questions & Answers

Filtering records of a csv file based on a value of a column

Hi, I tried filtering the records in a csv file using "awk" command listed below. awk -F"~" '$4 ~ /Active/{print }' inputfile > outputfile The output always has all the entries. The same command worked for different users from one of the forum links. content of file I was... (3 Replies)
Discussion started by: sunilmudikonda
3 Replies

LEARN ABOUT CENTOS

ipmicmd

openipmicmd(1)						     An IPMI Command Interface						    openipmicmd(1)

NAME

       openipmicmd - An IPMI Command Interface

SYNOPSIS

       openipmicmd [-k entry-to-execute] <connection parms>

DESCRIPTION

       The  openipmicmd program allows a user to execute direct IPMI commands.	It can work with direct interface with the OpenIPMI driver or with
       IPMI LAN interfaces.

OPTIONS

       -k entry-to-execute
	      Execute a single command an exit.

       <connection parms>
	      The parameters for the connection depend on the connection type.	These are all described in openipmi_conparms (7)

COMMANDS

       Once up, you can execute commands in the user interface.  Note that commands and responses are asynchronous, you issue a  command  and  the
       interface returns immediately.  When the response comes back, it will be dumped on your console.  That's a little strange looking, but IPMI
       is asynchronous underneath.  Note that the -k option is synchronous, it will wait for the response or a timeout before returning.

       0f lun netfn cmd [data1 [data2 ...]]
	      Send a command to the BMC you are connected to.

       channel [ipmb] IPMB-addr lun netfn [seq] cmd [data1 [data2 ...]]
	      Send a command to a device on the IPMB bus.  The "ipmb" string is optional.  The seq must be provided if the netfn is a response (an
	      odd number).  It must be the same sequence number that came in on the command in the "Command Sequence = seq" part of the command.

       channel 00 IPMB-addr lun netfn cmd [data1 [data2 ...]]
	      Send a broadcast command to a device on the IPMB bus.

       channel lan handle remote-swid local-swid lun netfn cmd [data1 [data ...]]
	      Send  a  command	to  a device over a LAN channel.  Note that this not the same as a LAN connection.  This sends a message through a
	      local BMC to a remote system that is hooked up with a LAN connection.

       test_lat count command
	      Executes the given commands (one of the previous commands) count times and gives the average time per command to execute.  Note that
	      "count" is hexadecimal.

       help   Display some help.

       regcmd netfn cmd
	      Register to receive the given command.  If the driver receives an external command, it will print it out.  This only works with sys-
	      tem interface connections, it will not work on LAN connections.

       unregcmd netfn cmd
	      Remove a command registration.

SEE ALSO

       ipmi_ui(1), ipmilan(8), openipmi_conparms(7)

KNOWN PROBLEMS

       The asynchronous nature of the program can be annoying.

AUTHOR

       Corey Minyard <cminyard@mvista.org>

OpenIPMI							     05/13/03							    openipmicmd(1)
All times are GMT -4. The time now is 03:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy