Sort, sed, and zero padding date column csv bash scripting Post: 302834883

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to insert a sequence number column inside a pipe delimited csv file using shell scripting?

Hi All, I need a shell script which could insert a sequence number column inside a dat file(pipe delimited). I have the dat file similar to the one as shown below.. |A|B|C||D|E |F|G|H||I|J |K|L|M||N|O |P|Q|R||S|T As shown above, the column 4 is currently blank and i need to insert sequence...

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

3. Shell Programming and Scripting

Sort data by date and then search by column

Hi, I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates. NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15...

4. Shell Programming and Scripting

Padding a csv value with 0's

I have this csv file that I would like to sort on the 20th and 21st field. They are high lighted below. My challenge is that when I sort on those fields they are not in order as I would have liked. It seems like I have to pad those fields to the longest value in that fields data. ...

5. Shell Programming and Scripting

sed --> sort data by date

Hi, i "tried" to sort data by date. So far, i used sed to take the data from the last and the actual month. Now, after changing the year it is not working properly. i use: GNU bash, version 4.2.45(1)-release (x86_64-suse-linux-gnu) sed -n '/\//p' $Home/../scripte/pd_0.txt y is a...

6. Shell Programming and Scripting

Bash - delete from csv all the row if the first column is length >

Hi guys, i have a csv file like: USERID;COG;DESCR;FIL;OFF user001;user;test1;001;A01 user002;user;test2;002;A02 user0003;user;test3;003;A03 user004;user;test4;004;A04 user0005;user;test5;005;A05 etc.. I need to read line for line and, if value of first column is > 7 char (in this example...

7. Shell Programming and Scripting

Need a piece of shell scripting to remove column from a csv file

Hi, I need to remove first column from a csv file and i can do this by using below command. cut -f1 -d, --complement Mytest.csv I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine. I have 5 files in my directory and...

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

9. Shell Programming and Scripting

Csv files sort by date and zip monthly

Hi, I'm an absolute beginner in shell programming. I would need a script for a NAS that makes the csv files sorted by date and always monthly a zip. In the current month, the data should be integrated into this folder, so there are only monthly files. Thanks for your help

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

html::formfu::filter::compoundsprintf

HTML::FormFu::Filter::CompoundSprintf(3pm)		User Contributed Perl Documentation		HTML::FormFu::Filter::CompoundSprintf(3pm)

NAME

       HTML::FormFu::Filter::CompoundSprintf - CompoundSprintf filter

SYNOPSIS

	   ---
	   element:
	     - type: Multi
	       name: date

	       elements:
		 - name: day
		 - name: month
		 - name: year

	       filter:
		 - type: CompoundSprintf
		   sprintf: '%02d-%02d-%04d'

	   # get the compound-value

	   my $date = $form->param_value('date');

DESCRIPTION

       For use with a HTML::FormFu::Element::Multi group of fields.

       Uses a sprintf pattern to join the input from several fields into a single value.

METHODS

   sprintf
       Arguments: $string

       "sprintf" pattern used to join the individually submitted parts.  The pattern is passed to the perl-core "sprintf" function.

   field_order
       Inherited. See "field_order" in HTML::FormFu::Filter::_Compound for details.

	   ---
	   element:
	     - type: Multi
	       name: date

	       elements:
		 - name: month
		 - name: day
		 - name year

	       filter:
		 - type: CompoundSprintf
		   field_order:
		     - day
		     - month
		     - year

AUTHOR

       Carl Franks, "cfranks@cpan.org"

LICENSE

       This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-01-23				HTML::FormFu::Filter::CompoundSprintf(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to insert a sequence number column inside a pipe delimited csv file using shell scripting?

Discussion started by: nithins007

2. UNIX for Dummies Questions & Answers

Sort csv file by duplicated column value

Discussion started by: jl487

3. Shell Programming and Scripting

Sort data by date and then search by column

Discussion started by: samrat dutta

4. Shell Programming and Scripting

Padding a csv value with 0's

Discussion started by: GroveTuckey