Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Adding the corresponding values for every 5th consecutive numbers
Top Forums Shell Programming and Scripting Adding the corresponding values for every 5th consecutive numbers Post 302871041 by NamS on Tuesday 5th of November 2013 11:03:40 AM
Old 11-05-2013
Adding the corresponding values for every 5th consecutive numbers
Dear All,

I have a file which is as follows:

Input File:

Code:
231    100.1
233     99
235     200.9
238     80.1
239     90.2
240     77.0
243     99.5
245     16.20
246     13.55
247     11.8
249     13.7
250     99.6

Expected Output:

Code:
231    400
237    247.3
243    141.05
249    113.3

Logic: The 1st column is printing every 5th number in the consecutive order(does not matter if it is not present in the input file). But it starts with the 1st number of the Column 1 and then prints every 5th number.

The second column prints the addition of all the 5 numbers. For example, 232 is not present, therefore we consider 0 corresponding to 232.

I am new in the field and would appreciate tour help.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting a range of consecutive numbers into a text file

I have a text file in the following format .... START 1,1 2,1 3,1 .. .. 9,1 10,1 END .... I want to change to the output to .... START 1,1 2,1 3,1 .. (4 Replies)
Discussion started by: VNR
4 Replies

2. Shell Programming and Scripting

concatenate consecutive field values

Hi, I have a file like this A Bob A Sam A John B David C Paul C Sandra If the consecutive field values in column one is same, then concatenate the corresponding strings. So, I need an output like this, A Bob_Sam_John B David C Paul_Sandra I usually work with excel but... (3 Replies)
Discussion started by: polsum
3 Replies

3. Programming

FORTRAN: Getting Consecutive DIST Values

I have this code and I want to get the first two consecutive distances (obtained by calling GET_TH(IT, 'DIST', DIST) at index IT, the result stored in DIST) for which (ITFLG(IT) .NE. 1). L_FIRST get the first DIST for which ITFLG(IT) .NE. 1. Getting a bit confused on how to achieve this. ... (0 Replies)
Discussion started by: kristinu
0 Replies

4. Shell Programming and Scripting

Finding consecutive numbers in version names on a txt file

Hi all. I have a directory which contains files that can be versioned. All the files are named according to a pattern like this: TEXTSTRING1-001.EXTENSION TEXTSTRING2-001.EXTENSION TEXTSTRING3-001.EXTENSION ... TEXTSTRINGn-001.EXTENSION If a file is versioned, a file called ... (10 Replies)
Discussion started by: fox1212
10 Replies

5. Shell Programming and Scripting

Print consecutive numbers in column2

Hi, I have an input file of the following style input.txt The 4000 at the end indicates the total no. of columns in that row. I would like to replace all -1s with consecutive 1 and 2 and print the whole line again. So, the output would be output.txt Thanks in advance. (7 Replies)
Discussion started by: jacobs.smith
7 Replies

6. Shell Programming and Scripting

Disruption of consecutive numbers

I do have a tab delimited file with the following format 200 46 201 67 204 89 205 98 206 89 208 890 210 23 .. ... 100's of rows I would like to output the missing consecutive number of the first column. The expected output will be: (1 Reply)
Discussion started by: Lucky Ali
1 Replies

7. UNIX for Dummies Questions & Answers

How to combine and insert missing consecutive numbers - awk or script?

Hi all, I have two (2) sets of files that are based on some snapshots of database that I want to merge and insert any missing sequential number. Below are example representation of these files: file1: DATE TIME COL1 COL2 COL3 COL4 ID 01/10/2013 0800 100 ... (3 Replies)
Discussion started by: newbie_01
3 Replies

8. UNIX for Dummies Questions & Answers

Sum every 3 consecutive numbers in a column

Dear All, I have a file with only one column. And I want to add every 3 consecutive numbers together and print the result. Input File: 21.1 10 10 55 11 99 10 8 4 Expected Output: 41.1 (5 Replies)
Discussion started by: NamS
5 Replies

9. Shell Programming and Scripting

Check/print missing number in a consecutive range and remove duplicate numbers

Hi, In an ideal scenario, I will have a listing of db transaction log that gets copied to a DR site and if I have them all, they will be numbered consecutively like below. 1_79811_01234567.arc 1_79812_01234567.arc 1_79813_01234567.arc 1_79814_01234567.arc 1_79815_01234567.arc... (3 Replies)
Discussion started by: newbie_01
3 Replies

LEARN ABOUT OPENSOLARIS

iconv_1250

iconv_1250(5)                                           Standards, Environments, and Macros                                          iconv_1250(5)

NAME

       iconv_1250 - code set conversion tables for MS 1250 (Windows Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +----------------------------------------------------------------------+
       |                   Code Set Conversions Supported                     |
       +-------------+----------+--------------+----------+-------------------+
       |    Code     |  Symbol  | Target Code  | Symbol   |  Target Output    |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | ISO 8859-2   |iso2      |ISO Latin 2        |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | MS 852       |dos2      |MS-DOS Latin 2     |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | Mazovia      |maz       |Mazovia            |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | DHN          |dhn       |Dom Handlowy Nauki |
       +-------------+----------+--------------+----------+-------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   MS 1250 to ISO 8859-2
       For the conversion of MS 1250 to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |  ISO 8859-2    |   MS 1250      |  ISO 8859-2   |
       |24-211         | 40             |235             |273            |
       |212            | 251            |236             |276            |
       |213            | 40             |237             |274            |
       |214            | 246            |241             |267            |
       |215            | 253            |245             |241            |
       |216            | 256            |246-267         |40             |
       |217            | 254            |271             |261            |
       |221-231        | 40             |273             |40             |
       |232            | 271            |274             |245            |
       |233            | 40             |276             |265            |
       |234            | 266            |247             |365            |
       +---------------+----------------+----------------+---------------+

   MS 1250 to MS 852
       For the conversion of MS 1250 to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |    MS 852      |   MS 1250      |    MS 852     |
       |200-211        | 40             |311             |220            |
       |212            | 346            |312             |250            |
       |213            | 40             |313             |323            |
       |214            | 227            |314             |267            |
       |215            | 233            |315             |326            |
       |216            | 246            |316             |327            |
       |217            | 215            |317             |322            |
       |220-231        | 40             |320             |321            |
       |232            | 347            |321             |343            |
       |233            | 40             |322             |325            |
       |234            | 230            |323             |340            |
       |235            | 234            |324             |342            |
       |236            | 247            |325             |212            |
       |237            | 253            |326             |231            |
       |240            | 377            |327             |236            |
       |241            | 363            |330             |374            |
       |242            | 364            |331             |336            |
       |243            | 235            |332             |351            |
       |244            | 317            |333             |353            |
       |245            | 244            |334             |232            |
       |246            | 40             |335             |355            |
       |247            | 365            |336             |335            |
       |250            | 371            |337             |341            |
       |251            | 40             |340             |352            |
       |252            | 270            |341             |240            |
       |253            | 256            |342             |203            |
       |254            | 252            |343             |307            |
       |255            | 360            |344             |204            |
       |256            | 40             |345             |222            |
       |257            | 275            |346             |206            |
       |260            | 370            |347             |207            |
       |261            | 40             |350             |237            |
       |262            | 362            |351             |202            |
       |263            | 210            |352             |251            |
       |264            | 357            |353             |211            |
       |265-267        | 40             |354             |330            |
       |270            | 367            |355             |241            |
       |271            | 245            |356             |214            |
       |272            | 255            |357             |324            |
       |273            | 257            |360             |320            |
       |274            | 225            |361             |344            |
       |275            | 361            |362             |345            |
       |276            | 226            |363             |242            |
       |277            | 276            |364             |223            |
       |300            | 350            |365             |213            |
       |301            | 265            |366             |224            |
       |302            | 266            |367             |366            |
       |303            | 306            |370             |375            |
       |304            | 216            |371             |205            |
       |305            | 221            |372             |243            |
       |306            | 217            |374             |201            |
       |307            | 200            |375             |354            |
       |310            | 254            |376             |356            |
       +---------------+----------------+----------------+---------------+

   MS 1250 to Mazovia
       For the conversion of MS 1250 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |    Mazovia     |   MS 1250      |   Mazovia     |
       |200-213        | 40             |310-311         |40             |
       |214            | 230            |312             |220            |
       |215-216        | 40             |313-320         |40             |
       |217            | 240            |321             |245            |
       |220-233        | 40             |322             |40             |
       |234            | 236            |323             |243            |
       |235-236        | 40             |324-325         |40             |
       |237            | 246            |326             |231            |
       |240            | 377            |327-333         |40             |
       |241-242        | 40             |334             |232            |
       |243            | 234            |335-336         |40             |
       |244            | 40             |337             |341            |
       |245            | 217            |340-341         |40             |
       |246-252        | 40             |342             |203            |
       |253            | 256            |343             |40             |
       |254            | 252            |344             |204            |
       |255-256        | 40             |345             |40             |
       |257            | 241            |346             |215            |
       |260            | 370            |347             |207            |
       |261            | 361            |350             |40             |
       |262            | 40             |351             |202            |
       |263            | 222            |352             |221            |
       |264            | 40             |353             |211            |
       |265            | 346            |354-355         |40             |
       |266            | 40             |356             |214            |
       |267            | 372            |357-360         |40             |
       |270            | 40             |361             |244            |
       |271            | 206            |362             |40             |
       |272            | 40             |363             |242            |
       |273            | 257            |364             |223            |
       |274-276        | 40             |365             |40             |
       |277            | 247            |366             |224            |
       |300-303        | 40             |367             |366            |
       |304            | 216            |370-373         |40             |
       |305            | 40             |374             |201            |
       |306            | 225            |375-376         |40             |
       |307            | 200            |                |               |
       +---------------+----------------+----------------+---------------+

   MS 1250 to DHN
       For the conversion of MS 1250 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |      DHN       |   MS 1250      |     DHN       |
       |200-213        | 40             |306             |201            |
       |214            | 206            |307-311         |40             |
       |215-216        | 40             |312             |202            |
       |217            | 207            |313-320         |40             |
       |220-233        | 40             |321             |204            |
       |234            | 217            |322             |40             |
       |235-236        | 40             |323             |205            |
       |237            | 220            |324-325         |40             |
       |240            | 377            |326             |231            |
       |241-242        | 40             |327-333         |40             |
       |243            | 203            |334             |232            |
       |244            | 40             |335-336         |40             |
       |245            | 200            |337             |341            |
       |246-252        | 40             |340             |40             |
       |253            | 256            |341             |240            |
       |254            | 252            |342-345         |40             |
       |255-256        | 40             |346             |212            |
       |257            | 210            |347-351         |40             |
       |260            | 370            |352             |213            |
       |261            | 361            |353-354         |40             |
       |262            | 40             |355             |241            |
       |263            | 214            |356-360         |40             |
       |264            | 40             |361             |215            |
       |265            | 346            |362             |40             |
       |266            | 40             |363             |216            |
       |267            | 372            |364             |223            |
       |270            | 40             |365             |40             |
       |271            | 211            |366             |224            |
       |272            | 40             |367             |366            |
       |273            | 257            |370-371         |40             |
       |274-276        | 40             |372             |243            |
       |277            | 221            |373-376         |40             |
       |300-305        | 40             |                |               |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          18 Apr 1997                                                      iconv_1250(5)
All times are GMT -4. The time now is 11:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy