How to align/sort the column pairs of an csv file, based on keyword word specified in another file? Post: 303034653

9 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

Sort file based on column

Hi, My input file is $cat samp 1 siva 1 raja 2 siva 1 siva 2 raja 4 venkat i want sort this name wise...alos need to remove duplicate lines. i am using cat samp|awk '{print $2,$1}'|sort -u it showing raja 1

3. Shell Programming and Scripting

Pick the column value based on another column from .csv file

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. Main imp point, in my .csv file, third column is having price value with comma (1,20,300), it has...

4. UNIX for Dummies Questions & Answers

Sort csv file by duplicated column value

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 ...

5. 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",""...

6. 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...

7. 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...

8. 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...

9. UNIX for Beginners Questions & Answers

How to sort a column in excel/csv file?

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.

LEARN ABOUT DEBIAN

gst-convert

GST-CONVERT(1)							   User Commands						    GST-CONVERT(1)

NAME

       gst-convert - Smalltalk syntax converter and beautifier

DESCRIPTION

   Usage:
	      gst-convert [OPTION]... [INFILE [OUTFILE]] gst-convert [OPTION]... -o|--output OUTFILE INFILES

OPTIONS

       -q, --quiet
	      don't show any message

       -v, --verbose
	      print extra information while processing

       -f, --format=FORMAT
	      convert from given input format (supported formats are gst, gst2, sif, squeak)

       -F, --output-format=FORMAT convert to given output format (supported
	      formats are gst, gst2, squeak)

       -C, --class=REGEX
	      convert only classes matching REGEX

       -C, --class=+REGEX
	      in addition, convert classes matching REGEX

       -C, --class=-REGEX
	      do not convert classes matching REGEX

       -c, --category=REGEX
	      convert only classes whose category matches REGEX

       -c, --category=+REGEX
	      in addition, convert those whose category matches REGEX

       -c, --category=-REGEX
	      do not convert classes whose category matches REGEX

       -r, --rule='CODE->REPL'
	      look for CODE and replace it with REPL

       -o, --output OUTFILE
	      concatenate multiple input files into a single converted output file

       --help display this message and exit

       --version
	      print version information and exit

SEE ALSO

       The  full  documentation for gst-convert is maintained as a Texinfo manual.  If the info and gst-convert programs are properly installed at
       your site, the command

	      info gst

       should give you access to the complete manual.

gst-convert version 3.2.4					   December 2011						    GST-CONVERT(1)