Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with pulling / filtering data from a .csv
Top Forums Shell Programming and Scripting Help with pulling / filtering data from a .csv Post 302452167 by felipe.vinturin on Thursday 9th of September 2010 12:38:35 PM
Old 09-09-2010
As you have the host as a key, you can:
Code:
# cat TestFile.txt
hostA: IBM
hostA,serial,104DBAC
hostA,hostid,0xcfc0213b
hostB: Sun Microsystems sun4u Sun SPARC Enterprise M5000 Server
hostB,serial,BEF0949C7D
hostB,hostid,854574e2

# cat HostInv.sh
hostInvFile="TestFile.txt"
egrep -i 'sun' "${hostInvFile}" | awk -F":" '{print $1}' | \
while read hostKey
do
	egrep '^'"${hostKey}"'' "${hostInvFile}"
done

Of course, there are several ways to do the same thing!

I hope it helps.

Regads.

---------- Post updated at 13:38 ---------- Previous update was at 13:34 ----------
Quote:
Originally Posted by felipe.vinturin
As you have the host as a key, you can:
Code:
# cat TestFile.txt
hostA: IBM
hostA,serial,104DBAC
hostA,hostid,0xcfc0213b
hostB: Sun Microsystems sun4u Sun SPARC Enterprise M5000 Server
hostB,serial,BEF0949C7D
hostB,hostid,854574e2

# cat HostInv.sh
hostInvFile="TestFile.txt"
egrep -i 'sun' "${hostInvFile}" | awk -F":" '{print $1}' | \
while read hostKey
do
	egrep '^'"${hostKey}"'' "${hostInvFile}"
done

Of course, there are several ways to do the same thing!

I hope it helps.

Regads.
Maybe remove the egrep by changing the awk:
Code:
awk -F":" '/[S|s]un/ {print $1}' "${hostInvFile}"

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pulling data and following lines from file

I saw a few posts close to what i want to do, but they didn't look like they would work exactly.. or I need to think out of the box on this. I have a file that I keep server stats in for my own performance analysis. this file has the output from many commands in it (uptime, vmstats, ps, swap... (2 Replies)
Discussion started by: MizzGail
2 Replies

2. Shell Programming and Scripting

SFTP to server, pulling data and removing the data

Hi all, I have the following script, but are not too sure about the syntax to complete the script. In essence, the script must connect to a SFTP server at a client site with username and password located in a file on my server. Then change to the appropriate directory. Pull the data to the... (1 Reply)
Discussion started by: codenjanod
1 Replies

3. Shell Programming and Scripting

pulling different fields from a csv file

Hi, I have a requirment where I need to pull different columns from a .csv file. Here is the sample of the csv file. account,item,flag1,flag2,flag3,flag4,flag5,......feed,tran I will be have a config.txt file which will have the following information. item,flag5,flag10,feed,tran... (2 Replies)
Discussion started by: akdevula
2 Replies

4. Shell Programming and Scripting

Reading 2 CSV files and filtering data based on group

I have two CSV files in the following format: First file: GroupID, PID:TID, IP, Port Sample data: 0,1000:11,127.0.0.1,445 0,-1:-1,127.0.0.1,800 1,1000:11,127.0.0.1,445 1,-1:-1,127.0.0.1,900 2,1000:11,127.0.0.1,445 2,-1:-1,180.0.0.3,900 Second file: IP,Port,PID Sample data... (6 Replies)
Discussion started by: rakesh_arxmind
6 Replies

5. Shell Programming and Scripting

Pulling data from xml

Hi there, Please could anyone help with this. I have an xml file that contains repeating values eg <Rule name> AAAAA <Action> BBBBB </Action> <Data> CCCCC </Data> <Type> DDDDD </Type> </Rule name> <Rule name> A1A1A1A1 <Action> B1B1B1B1 </Action> <Data> C1C1C1C </Data> <Type>... (4 Replies)
Discussion started by: ssideel
4 Replies

6. Shell Programming and Scripting

Filtering data from text to csv

Hello, Is there a way to filerter data from a text file as shown below to a Column e.g. hostname nfsmount as two separate column. Currently I could get hostname and the mount is appearing below.. using this script #! /bin/bash for i in `cat fqdn.txt` do echo "$i ............ " >>... (3 Replies)
Discussion started by: Cy Pqa
3 Replies

7. Shell Programming and Scripting

BASH- Need help pulling data from .emlx

Hello, fellow computer junkies. First time poster! My boss wrote an application (Mavericks 10.9, Mountain Lion 10.8) that checks a user's security settings. The user runs the application, then it spits out an email that is sent back to our inbox showing the results. On our end, we have a mail rule... (5 Replies)
Discussion started by: sudo
5 Replies

8. Shell Programming and Scripting

Pulling Data, Then Moving to the Next File

I'm scanning a list of emails- I need to pull 2 pieces of data, then move to the next file: Sender's Email Address Email Date I need these to be outputted into a single column- separated by a ",". Like this: Email1's Address, Email1's Date Stamp Email2's Address, Email2's Date Stamp... (4 Replies)
Discussion started by: sudo
4 Replies

9. Shell Programming and Scripting

Need help with csv filtering

Hello everyone, i am stuck with a task i was meant to do so i came here. So i have a .csv file which structure is : year;temperature;precipitation 2012;32;483 2006;28;517 ... I want to note that it is in fact ";" not a space, which a new file named <old-name>-new.txt, the first line must ... (2 Replies)
Discussion started by: Needhelp123
2 Replies

LEARN ABOUT SUNOS

wnnhosts

wnnhosts(4)							   File Formats 						       wnnhosts(4)

NAME

       wnnhosts - Wnn6 Kana-Kanji conversion server/dictionary lookup server access control file

SYNOPSIS

       /etc/lib/locale/ja/wnn/wnnhosts

DESCRIPTION

       wnnhosts  specifies users who can use the Wnn6 Kana-Kanji conversion server (jserver) and the Kana-Kanji conversion server that can be con-
       nected to the Wnn6 dictionary lookup server (wnnds).

       The following is the format of the access control file. Place a	space character before "{".

	    jserver	   ja	<Kana-Kanji conversion server>	   {
	    <access control data>
		 :
	    }
	    wnnds	   ja	<dictionary lookup server>    {
	    <access data>
		 :
	    }

       <Kana-Kanji conversion server>  is specified in the following format.

       hostname 	       The Kana-Kanji conversion server that uses the well-known port number(22273) on host hostname.

       hostname/port_no        The Kana-Kanji conversion server that uses port_no as port number on host hostname.

       <dictionary lookup server> is specified in the following format.

       hostname 	       The dictionary lookup server that uses the well-known port number(26208) on host hostname.

       hostname/port_no        The dictionary lookup server that uses  port_no as port number on host hostname.

       <access control data> for jserver is specified in the following format.

       hostname 	       All the users on the host can use data.

       hostname:username_list  username_list contains a list of username separated with ",". Users listed in the list on this host can use data.

       @username	       This user can use data from any host.

       <access control data> for wnnds is specified in the following format.

       hostname jserver on this host can be connected.

       jserver and wnnds use the access control information with the host name and port number matched.

       Lines beginning with ";" are comments.

EXAMPLES

       Example 1:

       jserver ja_JP hostA {
       ;hostC:usr1,usr2,usr3
       hostA:usr1,usr4
       hostB
       hostC:usr5
       @usrA
       ;usrB
       }

       wnnds ja_JP hostA {
       hostA
       hostD
       }

       jserver ja_JP hostA/22273 {
       hostB
       hostE
       @usrA
       }

       wnnds ja_JP hostA/22385 {
       hostA
       hostD
       }

SEE ALSO

       jserver(1M), wnnaccess(1M), wnnds(1M)

SunOS 5.10							    10 Jan 2003 						       wnnhosts(4)
All times are GMT -4. The time now is 01:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy