Sponsored Content
Top Forums Shell Programming and Scripting Sort and list values from CSV Post 302871101 by Nevergivup on Tuesday 5th of November 2013 01:21:37 PM
Old 11-05-2013
Hi Askshay ,

Below is my code:

Code:
#!/bin/sh
#
SortOutput $OutputCSV $abc

function SortOutput
{
 awk -F, '$6 < 60 {exit}1' <(sort -t, -nk3,3 $1)  >>$2
}

 

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies

2. Shell Programming and Scripting

sort the csv file

hello , the content of a csv file is looking like this... vah1 , imk4 , LDAP Secure. vah1 , fmk1 , Not able to SSH vah1 , fk1 ,Not able to SSH vah1 , imk1 , LDAP Secure. vah1 , imk3 , Un-Secured vah1 , fmk1 , LDAP Secure. vah1 , fk1 , LDAP Secure. vah1 , fmk1 , LDAP Secure. vah1 ,... (2 Replies)
Discussion started by: nagendramv
2 Replies

3. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you... (3 Replies)
Discussion started by: phoeberunner
3 Replies

4. Shell Programming and Scripting

Sort csv file

Hello, I am facing the following problem: I have a file in csv format. So several records where data fields are separated by comma ',' The lenght of the fields is variable, as well as the number of fields per record. But there are at least 7 fields per record. I need to sort the file based... (1 Reply)
Discussion started by: BSF
1 Replies

5. Shell Programming and Scripting

List unique values and count instances in .csv file

I need to take the second column of a .csv file and count the number of instances of each unique value in that same second column. I'd like the output to be value,count sorted by most instances. Thanks for any guidance! Data example: 317476,317756,0 816063,318861,0 313123,319091,0... (4 Replies)
Discussion started by: batcho
4 Replies

6. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

7. Shell Programming and Scripting

How to find the X highest values in a list depending on the values of another list with bash/awk?

Hi everyone, This is an exemple of inpout.txt file (a "," delimited text file which can be open as csv file): ID, Code, Value, Store SP|01, AABBCDE, 15, 3 SP|01, AABBCDE, 14, 2 SP|01, AABBCDF, 13, 2 SP|01, AABBCDE, 16, 3 SP|02, AABBCED, 15, 2 SP|01, AABBCDF, 12, 3 SP|01, AABBCDD,... (1 Reply)
Discussion started by: jeremy589
1 Replies
LedgerSMB::Location(3pm)				User Contributed Perl Documentation				  LedgerSMB::Location(3pm)

NAME
LedgerSMB::Location - LedgerSMB class for managing Business Locations SYOPSIS
This module contains location management routines. This subclasses LedgerSMB::DBObject to provide access to automatice mapping of function arguments and the like. METHODS
delete save Saves the location. Properties to be set to be saved are: * location_id: Optional: Overwrite location with this id. * address1: First line of the address. * address2: Second line of the address * address3: Third line of the address * city * state: state or province * zipcode: zipcode or mail code, * country: The id of the country as per the country table get Retrieves a location record based on the id field of the object. Merges the properties into the object. search Returns anarrayref (and stores it on $self->{search_results} based on the search of addresses. Not currently used. Attributes used as search criteria: address1: Partial match for address line 1 address2: Partial match for address line 2, city: Partial match for city name state: Partial match for state or province name, zipcode: Partial match for zip or postal code, country: Partial name for country name) list_all Provides a list of all locations, ordered by country, then city, then state. delete Deletes the location identified by id Copyright (C) 2007, The LedgerSMB core team. This file is licensed under the Gnu General Public License version 2, or at your option any later version. A copy of the license should have been included with your software. perl v5.14.2 2011-07-06 LedgerSMB::Location(3pm)
All times are GMT -4. The time now is 05:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy