Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Getting Distinct values from second field in a file....
Top Forums Shell Programming and Scripting Getting Distinct values from second field in a file.... Post 302333643 by simi28 on Monday 13th of July 2009 05:21:26 PM
Old 07-13-2009
Getting Distinct values from second field in a file....
Hi

I have a pipe delimited file. I am trying to grab the DISTINCT value from the second field. The file is something like:

1233|apple|ron
1234|apple|elephant
1235|egg|man

the output I am trying to get from second field is apple,egg (apple coming only once)

Thanks
simi
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Loop through only the distinct values in a file

Datafile has the following data seperated by : FIELD1:FIELD2:FIELD3 D1:/opt/9.1.9:Y D2:/opt/10.1.10:Y D3:/opt/9.1.9:Y D4:/opt/8.1.8:Y D5:/opt/8.1.8:Y D6:/opt/9.1.9:Y D7:/opt/9.1.9:Y D8:/opt/10.1.10:Y D9:/opt/9.1.9:Y D10:/opt/10.1.10:Y I want to do some operations only on the distinct... (2 Replies)
Discussion started by: pbekal
2 Replies

2. Shell Programming and Scripting

grep distinct values

this is a little more complex than that. I have a text file and I need to find all the distinct words that appear in a line after the word TABLESPACE when I grep for just the word tablespace, I get: how do i parse this a little better so i have a smaller file to read? This is just an... (4 Replies)
Discussion started by: guessingo
4 Replies

3. Shell Programming and Scripting

Select distinct values from a flat file

Hi , I have a similar problem. Please can anyone help me with a shell script or a perl. I have a flat file like this fruit country apple germany apple india banana pakistan banana saudi mango india I want to get a output like fruit country apple ... (7 Replies)
Discussion started by: smalya
7 Replies

4. UNIX for Dummies Questions & Answers

distinct values of all the fields

I am a beginner to scripting, please help me in this regard. How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (1 Reply)
Discussion started by: vukkusila
1 Replies

5. Shell Programming and Scripting

distinct values of all the fields

I am a beginner to scripting, please help me in this regard. How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (2 Replies)
Discussion started by: vukkusila
2 Replies

6. Shell Programming and Scripting

average of distinct values with awk

Hi guys, I am not an expert in shell and I need help with awk command. I have a file with values like 200 1 1 200 7 2 200 6 3 200 5 4 300 3 1 300 7 2 300 6 3 300 4 4 I need resulting file with averages of... (3 Replies)
Discussion started by: saif
3 Replies

7. Shell Programming and Scripting

Get the distinct of a particular field

From the below ps output , I want the distinct values of the third field (ie. I need the distinct PPIDs) $ ps -ef UID PID PPID C STIME TTY TIME CMD root 1 0 0 Nov 10 - 48:49 /etc/init root 1769576 1 0 Nov 10 - 0:07... (1 Reply)
Discussion started by: polavan
1 Replies

8. Shell Programming and Scripting

Find distinct values

Hi, I have two files of the following format file1 chr1:345-456 chr2:123-456 chr2:455-678 chr3:456-789 chr3:444-555 file2 chr1:345-456 chr2:123-456 chr3:456-789 output (2 Replies)
Discussion started by: jacobs.smith
2 Replies

9. Shell Programming and Scripting

Command to identify distinct field value

Could anyone help me on a command to identify distinct values from a particular column ?my input file has header. So i need a command in which we pass Column1 as parameter. For eg my input is like Column1 Column2 Column3 ... (4 Replies)
Discussion started by: krish123
4 Replies

10. Shell Programming and Scripting

Need distinct values from command in a script

Hello, I am using below command srvctl config service -d cmdbut cmdbut_01 (P):/devoragridcn_01/app/oracle> srvctl config service -d cmdbut Service name: boms10.world Service is enabled Server pool: cmdbut_boms10.world Cardinality: 1 Disconnect: false Service role: PRIMARY Management... (7 Replies)
Discussion started by: Vishal_dba
7 Replies

LEARN ABOUT MOJAVE

reportcrash

ReportCrash(8)						    BSD System Manager's Manual 					    ReportCrash(8)

NAME

     ReportCrash -- Generates crash reports

SYNOPSIS

     ReportCrash

DESCRIPTION

     ReportCrash analyzes crashing processes and saves a crash report to disk.	A crash report contains information that can help a developer
     diagnose the cause of a crash.  ReportCrash also records the identity of the crashing process and the location of the saved crash report in
     the system.log and the ASL log database.

     ReportCrash is invoked automatically by launchd when a crash is detected.	For applications and other processes running in the per-user
     launchd context, ReportCrash runs as a LaunchAgent and saves crash reports in the user's ~/Library/Logs/DiagnosticReports/ directory.  For
     daemons, other processes running in the system launchd context and other privileged processes, ReportCrash runs as a LaunchDaemon and saves
     crash reports in the system's /Library/Logs/DiagnosticReports directory where they are only readable by admin users.  If there are too many
     crash reports saved for a particular process, older reports will automatically be removed in order to conserve disk space.

     launchtl can be used to disable and re-enable crash reporting.  To disable crash reporting:

	   launchctl unload -w /System/Library/LaunchAgents/com.apple.ReportCrash.plist
	   sudo launchctl unload -w /System/Library/LaunchDaemons/com.apple.ReportCrash.Root.plist

     To re-enable crash reporting:

	   launchctl load -w /System/Library/LaunchAgents/com.apple.ReportCrash.plist
	   sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.ReportCrash.Root.plist

     For application crashes (but not background process crashes) ReportCrash will display a dialog notifying the user that the application unex-
     pectedly quit and offering to reopen the application or send the report to Apple.	For developers, the behavior of this dialog can be
     adjusted using /Developer/Applications/Utilities/CrashReporterPrefs.app which is installed as part of the developer tools.

     Crash reports which are sent to Apple are submitted anonymously by the SubmitDiagInfo process.  The reports are used by Apple to improve its
     products.	Users who need support should use http://www.apple.com/support or other authorized support channels.  Developers who are ADC mem-
     bers should report bugs using http://bugreporter.apple.com in order to allow for two way communication between Apple and the bug reporter.

     More information about interpreting the contents of crash reports can be found in Technote 2123: https://developer.apple.com/library/con-
     tent/technotes/tn2004/tn2123.html

SEE ALSO

     launchd(8), launchd.plist(8), launchctl(8), spindump(8), SubmitDiagInfo(8)

Mac OS								   June 1, 2019 							    Mac OS
All times are GMT -4. The time now is 04:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy