Sponsored Content
Top Forums Shell Programming and Scripting Extract difference of two columns from different rows Post 302398288 by sam_2921 on Wednesday 24th of February 2010 06:56:46 AM
Old 02-24-2010
Thanks Franklin, the code is working perfect. Please tell me what does ? and : work for in the expression ( s?$2-s:"0" ). Thanks again.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Difference between two rows

Dears, I have a list as follows, 2 4 8 If I want to find the difference between two consecutive rows. Then I have to store the specific rows in two variables and then find the difference. Could someone tell how this can be done. Regards, (7 Replies)
Discussion started by: JimJim
7 Replies

2. Shell Programming and Scripting

Difference between corresponding elements of successive rows

Hi, I have a file in the following format a1 b1 c1 d1 a2 b2 c2 d2 a3 b3 c3 d3 a4 b4 c4 d4 I need a script to find the difference between corresponding values of successive rows. So the output would have one less row than the input file and should look like: a2-a1 b2-b1 c2-c1 d2-d1... (4 Replies)
Discussion started by: sajal.bhatia
4 Replies

3. Shell Programming and Scripting

Extract values from a matrix given the rows and columns

Hi All, I have a huge (and its really huge!) matrix about 400GB in size (2 million rows by 1.5 million columns) . I am trying to optimize its space by creating a sparse representation of it. Miniature version of the matrix looks like this (matrix.mtx): 3.4543 65.7876 54.564 2.12344... (4 Replies)
Discussion started by: shoaibjameel123
4 Replies

4. Shell Programming and Scripting

Extract several columns with few rows

Hello, I want to extract several columns and rows from a huge tab delimited file for example: I want to print from from column 3 to 68 till row number 30. I have tried using cut command but it was extracting whole 3rd and 68th column. Please suggest a solution. Ryan (8 Replies)
Discussion started by: ryan9011
8 Replies

5. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

6. UNIX for Dummies Questions & Answers

Finding difference in 1st field for rows of data

I have a file that has multiple lines, of grouped data, that typically all have the same values in the 1st field, however, I would like to search the 1st field for any differences and set a flag to use in an "if" statement to run some other routine. An example of the typical file is below,... (2 Replies)
Discussion started by: co21ss
2 Replies

7. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies

8. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

9. Shell Programming and Scripting

Extract rows with different values at 2 columns

Hallo, I would need to extract only rows which has different value in the second and third column. Thank you very much for any advices Input: A 0 0 B 0 1 C 1 1 D 1 3 Output B 0 1 D 1 3 (4 Replies)
Discussion started by: kamcamonty
4 Replies

10. Shell Programming and Scripting

Calculating Time difference Between two Rows in Linux

16:45:51 10051 77845 16:45:51 10051 77845 16:46:52 10051 77846 16:46:53 10051 77846 Match the last PID then subtract second line time with first line. Please help me with any command or script. working in media company on a project OS: RHEl7 tried command: awk 'function... (2 Replies)
Discussion started by: vivekn
2 Replies
Mail::SpamAssassin::Plugin::ReplaceTags(3)		User Contributed Perl Documentation		Mail::SpamAssassin::Plugin::ReplaceTags(3)

NAME
Mail::SpamAssassin::Plugin::ReplaceTags - tags for SpamAssassin rules The plugin allows rules to contain regular expression tags to be used in regular expression rules. The tags make it much easier to maintain complicated rules. Warning: This plugin relies on data structures specific to this version of SpamAssasin; it is not guaranteed to work with other versions of SpamAssassin. SYNOPSIS
loadplugin Mail::SpamAssassin::Plugin::ReplaceTags replace_start < replace_end > replace_tag A [a@] replace_tag G [gk] replace_tag I [il|!1y?xccxcdxcexcfxecxedxeexef] replace_tag R [r3] replace_tag V (?:[vu]|\/) replace_tag SP [s~_-] body VIAGRA_OBFU /(?!viagra)<V>+<SP>*<I>+<SP>*<A>+<SP>*<G>+<SP>*<R>+<SP>*<A>+/i describe VIAGRA_OBFU Attempt to obfuscate "viagra" replace_rules VIAGRA_OBFU RULE DEFINITIONS AND PRIVILEGED SETTINGS
replace_tag tagname expression Assign a valid regular expression to tagname. Note: It is not recommended to put quantifiers inside the tag, it's better to put them inside the rule itself for greater flexibility. replace_pre tagname expression Assign a valid regular expression to tagname. The expression will be placed before each tag that is replaced. replace_inter tagname expression Assign a valid regular expression to tagname. The expression will be placed between each two immediately adjacent tags that are replaced. replace_post tagname expression Assign a valid regular expression to tagname. The expression will be placed after each tag that is replaced. replace_rules list_of_tests Specify a list of symbolic test names (separated by whitespace) of tests which should be modified using replacement tags. Only simple regular expression body, header, uri, full, rawbody tests are supported. replace_start string replace_end string String(s) which indicate the start and end of a tag inside a rule. Only tags enclosed by the start and end strings are found and replaced. perl v5.12.1 2010-03-16 Mail::SpamAssassin::Plugin::ReplaceTags(3)
All times are GMT -4. The time now is 07:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy