Extract difference of two columns from different rows Post: 302398272

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,

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

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

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

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

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

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

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

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

LEARN ABOUT DEBIAN

nsaconv

onscripter(6)							   Games Manual 						     onscripter(6)

NAME

       nsaconv -- NSA archive converter

SYNOPSIS

       nsaconv [-e]  [-j]  [-ns2]  [-ns3]  [-q quality]  src_width dst_width src_archive_file dst_archive_file

DESCRIPTION

       This manual page documents briefly the nsaconv command.

       This manual page was written for the Debian distribution because the original program does not have a manual page.

       nsaconv is a program that converts the archive file of the visual novel games engine ONScripter into different width or quality. It is use-
       ful to adjust the size of the archive file. And it is also useful to adjust the width of the game for playing on some hand-held game  plat-
       form like PSP.

       The src_width should be 640 or 800. And the dst_width can be 176, 220, 320, 360, 384, 640, and etc.

OPTIONS

		 -e
		 Enhanced mode.

		 -j
		 Convert BMPs to JPGs.

		 -ns2
		 The archive type is NS2.

		 -ns3
		 The archive type is NS3.

		 -q quality
		 Adjust JPEG quality, from 0 to 100.

SEE ALSO

       onscripter (6), nsadec (6), sardec (6).

AUTHOR

       This  manual page was written by Ying-Chun Liu (PaulLiu) grandpaul@gmail.com for the Debian system (but may be used by others).	Permission
       is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any  later  version
       published by the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

																     onscripter(6)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Difference between two rows

Discussion started by: JimJim

2. Shell Programming and Scripting

Difference between corresponding elements of successive rows

Discussion started by: sajal.bhatia

3. Shell Programming and Scripting

Extract values from a matrix given the rows and columns

Discussion started by: shoaibjameel123

4. Shell Programming and Scripting

Extract several columns with few rows

Discussion started by: ryan9011