Sponsored Content
Top Forums Shell Programming and Scripting extract data in a csv file based on a certain field. Post 302517794 by rdcwayx on Wednesday 27th of April 2011 08:26:01 PM
Old 04-27-2011
Code:
$ $ cat data
Field 1       Field2  Field3   Field4   Field5     Field6
20009756   1        2         1          1           592560
20007654   2        4         45brt      ewfw        55552
20009756   X        2         1          1           592560
20009756   balh        2         1          1           592560
20007654   8.t        4         45brt      ewfw        55552


$ awk '{print >$6 ".txt"}' infile

$ cat 592560.txt
20009756   1        2         1          1           592560
20009756   X        2         1          1           592560
20009756   balh        2         1          1           592560

or only print column 2 :
Code:
$awk '{print $2 >$6 ".txt"}' infile

$ cat 592560.txt
1
X
balh

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract data into file with specific field specs

:confused: I have a tab delimited file that I need to extract data from and into a file with specific field specs. Each field has to be a certain amount of characters. So, the name field (from delimited file) might have only 15 characters but needs to be 25 (in new file) so I need to insert spaces... (5 Replies)
Discussion started by: criddel
5 Replies

2. Shell Programming and Scripting

Extract data from an XML file & write into a CSV file

Hi All, I am having an XML tag like: <detail sim_ser_no_1="898407109001000090" imsi_1="452070001000090"> <security>ADM1=????</security> <security>PIN1=????</security> <security>PIN2=????</security> ... (2 Replies)
Discussion started by: ss_ss
2 Replies

3. Shell Programming and Scripting

How to extract data from csv file

Hello everybody, Here is my problem, I don't know anything about shell programming and my boss is actually asking me to develop a shell script in order to get values in a csv file from a specific date. Here is a sample of the csv file : Date;Enchaînement;Titre;Libellé ;calendrier;Heure début;Heure... (11 Replies)
Discussion started by: freyr
11 Replies

4. Shell Programming and Scripting

Extract file records based on some field conditions

Hello Friends, I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited): ColA|ColB|ColC|ColD|ColE|ColF Now for this file, I have to get those records which fulfil the following condition: If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Discussion started by: mehimadri
9 Replies

5. Shell Programming and Scripting

Text file to CSV with field data separated by blank lines

Hello, I have some data in a text file where fields are separated by blank lines. There are only 6 fields however some fields have several lines of data as I will explain. Also data in a particular field is not consistently the same size but does end on a blank line. The first field start with... (6 Replies)
Discussion started by: vestport
6 Replies

6. Shell Programming and Scripting

Matching and Merging csv data fields based on a common field

Dear List, I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this: date,hostname,status,color,check 02-03-2012,COMP1,FAIL,Yellow,auth_pass_change... (3 Replies)
Discussion started by: landossa
3 Replies

7. Shell Programming and Scripting

Extract data from XML file and write in CSV file

Hi friend i have input as following XML file <?xml version="1.0"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.054.001.02"> <BkToCstmrDbtCdtNtfctn> <GrpHdr><MsgId>LBP-RDJ-TE000000-130042430010001001</MsgId><CreDtTm>2013-01-04T03:21:30</CreDtTm></GrpHdr>... (3 Replies)
Discussion started by: mohan sharma
3 Replies

8. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file based on certain conditions

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Discussion started by: Vivekit82
1 Replies

9. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values. Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies

10. Shell Programming and Scripting

Shell script to extract data from csv file

Hi everyone, I have a csv file which has data with different heading and column names as below. Static Data Ingested ,,,,,,,,,,,,Known Explained Rejections Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Discussion started by: Vivekit82
14 Replies
SC_ATTACH(1)						    BSD General Commands Manual 					      SC_ATTACH(1)

NAME
sc_attach -- simple scamper driver. SYNOPSIS
sc_attach [-?v] [-i infile] [-o outfile] [-p port] DESCRIPTION
The sc_attach utility provides the ability to connect to a running scamper(1) instance, have a set of commands defined in a file be executed, and the output be written into a single file, in warts format. The options are as follows: -? prints a list of command line options and a synopsis of each. -i infile specifies the name of the input file which consists of a sequence of scamper(1) commands, one per line. If '-' is specified, com- mands are read from stdin. -o outfile specifies the name of the output file to be written. The output file will use the warts format. If '-' is specified, output will be sent to stdout. -p port specifies the port on the local host where scamper(1) is accepting control socket connections. -v prints the current revision of sc_attach and exits. EXAMPLE
Given a set of commands in a file named infile.txt: tbit -M 1280 -u 'http://www.example.com/' 2620:0:2d0:200::10 trace -P udp-paris -M 192.0.2.1 ping -P icmp-echo 192.0.32.10 and a scamper(1) daemon listening on port 31337, then these commands can be executed using sc_attach -i infile.txt -o outfile.warts -p 31337 SEE ALSO
scamper(1), sc_wartsdump(1), sc_warts2text(1) AUTHORS
sc_attach is written by Matthew Luckie <mjl@luckie.org.nz>. BSD
October 15, 2010 BSD
All times are GMT -4. The time now is 08:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy