sort the csv file Post: 302336933

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort csv file

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

2. Shell Programming and Scripting

How to sort columns in excel(csv) file

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

3. UNIX for Dummies Questions & Answers

Sort and join all .csv files

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

5. Shell Programming and Scripting

Sort on mm/dd/yyyy csv

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

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

7. Shell Programming and Scripting

Sort and list values from CSV

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

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

9. UNIX for Beginners Questions & Answers

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

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

LEARN ABOUT SUSE

eview

EVIM(1) 						      General Commands Manual							   EVIM(1)

NAME

       evim - easy Vim, edit a file with Vim and setup for modeless editing

SYNOPSIS

       evim [options] [file ..]
       eview

DESCRIPTION

       eVim  starts  Vim and sets options to make it behave like a modeless editor.  This is still Vim but used as a point-and-click editor.  This
       feels a lot like using Notepad on MS-Windows.  eVim will always run in the GUI, to enable the use of menus and toolbar.

       Only to be used for people who really can't work with Vim in the normal way.  Editing will be much less efficient.

       eview is the same, but starts in read-only mode.  It works just like evim -R.

       See vim(1) for details about Vim, options, etc.

       The 'insertmode' option is set to be able to type text directly.
       Mappings are setup to make Copy and Paste work with the MS-Windows keys.  CTRL-X cuts text, CTRL-C copies text and CTRL-V pastes text.  Use
       CTRL-Q to obtain the original meaning of CTRL-V.

OPTIONS

       See vim(1).

FILES

       /usr/share/vim/vim72/evim.vim
		      The script loaded to initialize eVim.

AKA

       Also  Known  As "Vim for gumbies".  When using evim you are expected to take a handkerchief, make a knot in each corner and wear it on your
       head.

SEE ALSO

       vim(1)

AUTHOR

       Most of Vim was made by Bram Moolenaar, with a lot of help from others.	See the Help/Credits menu.

								 2002 February 16							   EVIM(1)