Pick the column value based on another column from .csv file Post: 302758045

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sorting csv file based on column selected

Hi all, in my csv file it'll look like this, and of course it may have more columns US to UK;abc-hq-jcl;multimedia UK to CN;def-ny-jkl;standard DE to DM;abc-ab-klm;critical FD to YM;la-yr-tym;standard HY to MC;la-yr-ytm;multimedia GT to KJ;def-ny-jrt;critical I would like to group...

2. Shell Programming and Scripting

Read CSV column value based on column name

Hi All, I am newbie to Unix I ve got assignment to work in unix can you please help me in this regard There is a sample CSV file "Username", "Password" "John1", "Scot1" "John2", "Scot2" "John3", "Scot3" "John4", "Scot4" If i give the column name as Password and row number as 4 the...

3. Shell Programming and Scripting

Pick the column value based on another column using awk or CUT

My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated. Please someone help me to resolve this issue. Source column1 column2 column3 column4...

4. Shell Programming and Scripting

Pick the column value including comma from csv file using awk

Source 1 column1 column2 column 3 column4 1,ganesh,1,000,1 222,ram,2,000,5 222,ram,50,000,5 33,raju,5,000,7 33,raju,5,000,7 33,raju,5,000,8 33,raju,5,000,4 33,raju,5,000,1 In my .csv file, third column is having price value with comma (20,300), it has to be considered 1,000 as...

5. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, 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....

6. Linux

Filter a .CSV file based on the 5th column values

I have a .CSV file with the below format: "column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10 "12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""...

7. Shell Programming and Scripting

Fetching values in CSV file based on column name

input.csv: Field1,Field2,Field3,Field4,Field4 abc ,123 ,xyz ,000 ,pqr mno ,123 ,dfr ,111 ,bbb output: Field2,Field4 123 ,000 123 ,111 how to fetch the values of Field4 where Field2='123' I don't want to fetch the values based on column position. Instead want to...

8. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this?

9. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2...

10. UNIX for Beginners Questions & Answers

Filtering records of a csv file based on a value of a column

Hi, I tried filtering the records in a csv file using "awk" command listed below. awk -F"~" '$4 ~ /Active/{print }' inputfile > outputfile The output always has all the entries. The same command worked for different users from one of the forum links. content of file I was...

LEARN ABOUT HPUX

st_san_safe

st_san_safe(5)							     OBSOLETED							    st_san_safe(5)

NAME

       st_san_safe - determine whether access to tape device special files without the no-rewind-on-close option is allowed (OBSOLETED)

VALUES

   Failsafe
   Default
   Allowed values
   Recommended values
       or

DESCRIPTION

       Note: this tunable is obsoleted and has been renamed to beginning with release HP-UX 11i v3.

       This  tunable  notifies the tape driver whether it should allow access to device special files without the no-rewind-on-close option.  When
       this tunable is on the tape driver will fail any open on a tape device special file without the no-rewind-on-close option (that is, or with
       a status of

       The  tunable  allows  the  safe	sharing of tape devices in SAN tape backup solution configurations.  The disabling of device special files
       without no-rewind-on-close in a SAN tape backup solution configuration prevents the accidental sending of a rewind command  on  close  from
       HP-UX systems via standard tape commands like which would corrupt a backup in process.

   Who Is Expected to Change This Tunable?
       Anyone.

   Restrictions on Changing
       Changes to this tunable take effect immediately.

   When Should the Tunable Be Turned On?
       This tunable should be turned on if the system is going to be used in a SAN tape backup solution configuration.

   What Are the Side Effects of Turning the Tunable On?
       The  tape  driver  will	fail any open to a tape device special file that does not have the no-rewind-on-close option with a status of This
       behavior prevents the usage of any tape device special file without the no-rewind-on-close option.

   When Should the Tunable Be Turned Off?
       This tunable should be turned off if the system is not part of a SAN tape backup solution configuration or the  system  utilizes  will  not
       function unless it has access to device special files without the no-rewind-on-close option.

   What Are the Side Effects of Turning the Tunable Off?
       A rewind may be issued from this system accidentally on close possibly corrupting a backup being issued from another system on the SAN.

   What Other Tunables Should Be Changed at the Same Time?
       None.

WARNINGS

       All  HP-UX kernel tunable parameters are release specific.  This parameter may be removed or have its meaning changed in future releases of
       HP-UX.

       Installation of optional kernel software, from HP or other vendors, may cause changes to tunable  parameter  values.   After  installation,
       some  tunable  parameters may no longer be at the default or recommended values.  For information about the effects of installation on tun-
       able values, consult the documentation for the kernel software being installed.	For information about optional kernel  software  that  was
       factory installed on your system, see at

AUTHOR

       was developed by Hewlett-Packard.

SEE ALSO

       norewind_close_disabled(5), scsi_tape(7), scsimgr_estape(7).

							     Tunable Kernel Parameters						    st_san_safe(5)