How to perfrom summation for particular delimited field? Post: 302141410

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count field frequency in a '|' delimited file

I have a large file with fields delimited by '|', and I want to run some analysis on it. What I want to do is count how many times each field is populated, or list the frequency of population for each field. I am in a Sun OS environment. Thanks, - CB

2. Shell Programming and Scripting

insert a field into a tab delimited file

Hello, Can someone help me to do this with awk or sed? I have a file with multiple lines, each line has many fields separated with a tab. I would like to add one more field holding 'na' in between the first and second fields. old file looks like, 1, field1 field2 field3 ... 2, field1...

3. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Hello, I have about 100 files in a directory with fields which are tab delimited. I would like to append the file name as the first field and it has to be done as many times as the total lines in the file. For example, myFile1.txt has the following data: 1 x y z 2 a b ...

4. Shell Programming and Scripting

Using AWK to parse a delimited field

Hi everyone! How can I parse a delimited field using AWK? For example, if I have lastName#firstName or lastName*firstName. I'd like an AWK script that would return lastName and then another that would return firstName? Is this possible?

5. Shell Programming and Scripting

Pad zeroes first field in a Delimited file

Need help. I tried using an awk command to pad zeroes. Unfortunately, the "|" pipe delimited character is gone when I tried to write the records to another file. awk -F \| ' {$1=sprintf("%06s", $1); print $0}' $CUSTFINAL2 > $CUSTFINAL3 BEFORE "KEYRECORD"|"SA ID"|"PER ID"|"SP ID"|"ACCT...

6. UNIX for Dummies Questions & Answers

add new 'date field' in a pipe delimited file

i need to add a new field in a pipe delimited line. the field will be the current date today. aa|a|s|w|1 as|oiy|oiy|oiy|2 given that all lines are uniformed in the number of fields i want it to look like this:\ aa|a|s|w|1|20120126 as|oiy|oiy|oiy|2|20120126 please help :)

7. Programming

Field delimited data to XML

Hi, We need to produce a XML file based on a record/field delimited data file. At this point we could just script something out but I would like to ask the community what would be the best choice of programming language to do this, in terms of performance of execution, and in terms of complexity...

8. Shell Programming and Scripting

Remove Last field from a delimited file

Hi, I have a '~' delimited file and i want to remove the last field using awk. Please find the sample records below: 1428128~1~0~1100426~003~50220~005~14~0~194801~11~0~3~14~0~50419052335~0~0820652001~2~00653862 ~0~1~0~00126~1~20000110~20110423~R~ ~0~Z~1662.94~ ~002041~0045~Z~...

9. Shell Programming and Scripting

How can i comma-delimited last field in line?

Awk gurus, Greatly appreciate for any kind of assistance from the expert community Input line: abc,11.22.33.44,xyz,7-8-9-10 pqr,111.222.333.444,wxy,1-2-3 def,22.33.44.55,stu,7-8 used the gsub function below but it changes all of the "-" delimiter: awk 'gsub("-",",")' Desired...

10. Shell Programming and Scripting

Replace field in the delimited file

Hi, I have the requirement similar to the one mentioned in the below thread. https://www.unix.com/unix-for-dummies-questions-and-answers/128155-search-replace-string-only-particular-column-delimited-file.html The only difference is that I need to change the field for row 1,2 and the last...

LEARN ABOUT MOJAVE

ppi::statement::scheduled

PPI::Statement::Scheduled(3)				User Contributed Perl Documentation			      PPI::Statement::Scheduled(3)

NAME

       PPI::Statement::Scheduled - A scheduled code block

INHERITANCE

	 PPI::Statement::Scheduled
	 isa PPI::Statement::Sub
	     isa PPI::Statement
		 isa PPI::Node
		     isa PPI::Element

DESCRIPTION

       A scheduled code block is one that is intended to be run at a specific time during the loading process.

       There are five types of scheduled block:

	 BEGIN {
	       # Executes as soon as this block is fully defined
	       ...
	 }

	 CHECK {
	       # Executes after overall compile-phase in reverse order
	       ...
	 }

	 UNITCHECK {
	       # Executes after compile-phase of individual module in reverse order
	       ...
	 }

	 INIT {
	       # Executes just before run-time
	       ...
	 }

	 END {
	       # Executes as late as possible in reverse order
	       ...
	 }

       Technically these scheduled blocks are actually subroutines, and in fact may have 'sub' in front of them.

METHODS

   type
       The "type" method returns the type of scheduled block, which should always be one of 'BEGIN', 'CHECK', 'UNITCHECK', 'INIT' or 'END'.

TO DO

       - Write unit tests for this package

SUPPORT

       See the support section in the main module.

AUTHOR

       Adam Kennedy <adamk@cpan.org>

COPYRIGHT

       Copyright 2001 - 2011 Adam Kennedy.

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

       The full text of the license can be found in the LICENSE file included with this module.

perl v5.18.2							    2011-02-25					      PPI::Statement::Scheduled(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count field frequency in a '|' delimited file

Discussion started by: ChicagoBlues

2. Shell Programming and Scripting

insert a field into a tab delimited file

Discussion started by: ssshen

3. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Discussion started by: Gussifinknottle

4. Shell Programming and Scripting

Using AWK to parse a delimited field

Discussion started by: Fatbob