07-23-2009
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 , fmk1 , LDAP Secure.
vah1 , fmk1 , Un-Secured
vah1 , immk2 , Un-Secured
vah1 , fmmk1 , Un-Secured
vah1 , fmk1 , Un-Secured
vah1 , fmk1 , Un-Secured
vah1 , rmk1 , LDAP Secure.
vah2 , ssr , Un-Secured
vah2 , ib , Un-Secured
vah2 , fesh, LDAP Secure.
i want to group all those which are LDAP Secured, and the group of those which are Un-Secured and one more group for the Local Secure.
Thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi guys.
i am quite new to shell scripting. and i've been practicing coding
in a CSV (comma separated value) file is it possible to sort a specific block?
what do i do if i want to sort these contacts by their birthdays in ascending order (Jan. to Dec.)? And i want only to display their name... (6 Replies)
Discussion started by: mozart
6 Replies
2. Shell Programming and Scripting
i want sort columns with headers based on another file headers
file1
eg: i'm having an empty file with only coumn names like
lastname firstname title expirydate stlcno status etc...
another file with same column names and some other as well but in different order...
file2
eg:firstname... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies
3. UNIX for Dummies Questions & Answers
Hi ,
I have a dump of .csv files in a folder, I need to sort all files by the first 3 columns and merge them all in one big csv file.
I am using a cat command to join them, but how can i sort before appending all the files as one big file,
Regards,
Shruthi (4 Replies)
Discussion started by: shruthidwh
4 Replies
4. Shell Programming and Scripting
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
I have the following csv data that I would like to sort on the 4th field by date
from oldest to newest.
data:
,,,02/06/2012,Carry H,Add,Add,Sys_RTH,111.222.333.777
4/7/12,,,03/03/2013,Parry H,Add,Add,Sys_RTH,111.222.333.776
,,,12/06/2012,Harry H,Add,Add,Sys_RTH,111.222.333.778... (3 Replies)
Discussion started by: wbrunc
3 Replies
6. UNIX for Dummies Questions & Answers
hello, I have a large file (about 1gb) that is in a file similar to the following:
I want to make it so that I can put all the duplicates where column 3 (delimited by the commas) are shown on top. Meaning all people with the same age are listed at the top.
The command I used was ... (3 Replies)
Discussion started by: jl487
3 Replies
7. Shell Programming and Scripting
I have a CSV with below values
name,city,2,country
name,city,15,country
abc,wq,10,afdfd,
qeqe,ewqre,1,wqew
I need to sort them in ascending order based on the value of column 3 and then , pick the rows with values less than 10 and be able to display the columns in that row. Can anyone... (11 Replies)
Discussion started by: Nevergivup
11 Replies
8. UNIX for Beginners Questions & Answers
I have to sort the 4th column of an excel/csv file. I tried the following command
sort -u --field-separator=, --numeric-sort -k 2 -n dinesh.csv > test.csv
But, it's not working. Moreover, I have to do the same for more than 30 excel/csv file. So please help me to do the same. (6 Replies)
Discussion started by: dineshkumarsrk
6 Replies
9. UNIX for Beginners Questions & Answers
I have a csv file as shown below,
xop_thy 80 avr_njk 50 str_nyu 60
avr_irt 70 str_nhj 60 avr_ngt 50
str_tgt 80 xop_nmg 50 xop_nth 40
cyv_gty 40 cop_thl 40 vir_tyk 80
vir_plo 20 vir_thk 40 ijk_yuc 70
cop_thy 70 ijk_yuc 80 irt_hgt 80
I need to align/sort the csv file based... (7 Replies)
Discussion started by: dineshkumarsrk
7 Replies
LEARN ABOUT CENTOS
ssh-ldap-helper
SSH-LDAP-HELPER(8) BSD System Manager's Manual SSH-LDAP-HELPER(8)
NAME
ssh-ldap-helper -- sshd helper program for ldap support
SYNOPSIS
ssh-ldap-helper [-devw] [-f file] [-s user]
DESCRIPTION
ssh-ldap-helper is used by sshd(1) to access keys provided by an LDAP. ssh-ldap-helper is disabled by default and can only be enabled in the
sshd configuration file /etc/ssh/sshd_config by setting AuthorizedKeysCommand to ``/usr/libexec/openssh/ssh-ldap-wrapper''.
ssh-ldap-helper is not intended to be invoked by the user, but from sshd(8) via ssh-ldap-wrapper.
The options are as follows:
-d Set the debug mode; ssh-ldap-helper prints all logs to stderr instead of syslog.
-e Implies -w; ssh-ldap-helper halts if it encounters an unknown item in the ldap.conf file.
-f ssh-ldap-helper uses this file as the ldap configuration file instead of /etc/ssh/ldap.conf (default).
-s ssh-ldap-helper prints out the user's keys to stdout and exits.
-v Implies -d; increases verbosity.
-w ssh-ldap-helper writes warnings about unknown items in the ldap.conf configuration file.
SEE ALSO
sshd(8), sshd_config(5), ssh-ldap.conf(5),
HISTORY
ssh-ldap-helper first appeared in OpenSSH 5.5 + PKA-LDAP .
AUTHORS
Jan F. Chadima <jchadima@redhat.com>
BSD
April 29, 2010 BSD