Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to change a number on a specific lines in a file with shell?
Top Forums Shell Programming and Scripting How to change a number on a specific lines in a file with shell? Post 302605985 by miriammiriam on Friday 9th of March 2012 09:26:35 AM
Old 03-09-2012
Data How to change a number on a specific lines in a file with shell?
Hello

My problem is that I want to change some specific numbers in a file. It is like,

Code:
 2009 10 3 2349 21.3 L  40.719  27.388 10.8  FRO  7 0.8 1.1LFRO 2.6CFRO 1.1LMAM1
 GAP=157        1.69       5.7     5.9  5.8  0.5405E+01  0.4455E+00  0.1653E+02E
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO AIN AR TRES W  DIS CAZ7
 FRR1 SZ IP       2349 25.57                             153    0.7210 3.59  56
 FRR1 SE ES       2349 27.08                             153   -0.3510 3.59  56
 YNKM SZ IPG  0   2349 26.44   364.6e+01                 116    0.0510 11.9   4
 YNKM SZ ESG  1   2349 28.25     1.2e+02                 116   -1.85 7 11.9   4

 2009 10 4 1009  6.8 L  40.758  27.692 12.1  FRO 10 0.5 1.3LFRO 2.6CFRO 1.5LMAM1
 GAP=141        1.10       4.1     2.5  3.0  0.2367E+01  0.6141E+00 -0.3938E+01E
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO AIN AR TRES W  DIS CAZ7
 FRR4 SZ IP       1009 11.85                             122    0.5610 11.7 100
 FRR4 SN ES       1009 13.99                             122   -0.5810 11.7 100
 MADM SZ IPG  0   1009 12.08   266.3e+01                 122    0.3110 11.8 192
 MADM SZ ESG  1   1009 14.83     8.4e+01                 122   -0.57 7 11.8 192
 FRR2 SZ IP       1009 12.65                             109    0.5810 18.0 295
 FRR2 SE ES       1009 15.26                             109   -0.6510 18.0 295
 FRR1 SZ IP       1009 14.15                              61    0.7710 22.9 264


 2009 10 5 0705 27.2 L  40.477  29.166  5.5  FRO  7 0.7 1.2LFRO 2.4CFRO 1.3LMAM1
 GAP=124        1.57       4.4     5.9  6.6  0.4955E+01  0.1054E+02 -0.1047E+02E
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO AIN AR TRES W  DIS CAZ7
 ESKM SZ IP   0   0705 33.54     2.2e+01                  40   -0.0810 23.6 308
 ESKM SZ ES   1   0705 36.80     3.0e+01                  40   -1.48 7 23.6 308
 IGDM SZ IP   0   0705 33.88   201.4e+01                  40    0.1210 23.8 173

The number I want to edit is the number after FBO which is the 11th column in the header string.
(Ex: 2009 10 5 0705 27.2 L 40.477 29.166 5.5 FRO 7 0.7 1.2LFRO 2.4CFRO 1.3LMAM1)

All I need is to add 1.3 to that number. The line number between the blank lines vary.

I create two file one with "FRO number" and one with "FRO number+1.3" And tried to replace them with sed command.

Code:
sed 's/12.8  FRO/14.1  FRO/g' file1 > file2

but since the values repeated several time it went all the way wrong so that idea of mine became useless.

Any help would be appreciated...
Last edited by Corona688; 03-09-2012 at 11:46 AM.. Reason: Code tags for code please.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to read specific lines in a file

I have a file with contents as follows Record 1: Rejected - Error on table "DWO"."P2G_CUST_EVENTS". ORA-00001: unique constraint (DWO.CUST_EVENTS_PK) violated Record 5: Rejected - Error on table "DWO"."P2G_CUST_EVENTS". ORA-00001: unique constraint (DWO.CUST_EVENTS_PK) violated Record 6:... (5 Replies)
Discussion started by: varshanswamy
5 Replies

2. Shell Programming and Scripting

extract the lines between specific line number from a text file

Hi I want to extract certain text between two line numbers like 23234234324 and 54446655567567 How do I do this with a simple sed or awk command? Thank you. ---------- Post updated at 06:16 PM ---------- Previous update was at 05:55 PM ---------- found it: sed -n '#1,#2p'... (1 Reply)
Discussion started by: return_user
1 Replies

3. SCO

Why? I can not change the number of lines to print

hi My problem now is that if shipping options as -o length = 88 it says the following: # lp -o length=88 -dhp4015 /etc/hosts UX:lp: ERROR: The following options can't be handled: -o length= TO FIX: The printer(s) that otherwise qualify for printing your request can't handle one or more of... (2 Replies)
Discussion started by: Edgar Guevara
2 Replies

4. Shell Programming and Scripting

Delete all lines that start with a bigger number of a specific one.

E.g. the file is like this: I want to delete all lines that begin with a number larger than 2, ignoring the lines that doesn't begin with a number! PS:'2' is actually a variable that can have a lot of values:b:i bet you got it (10 Replies)
Discussion started by: hakermania
10 Replies

5. Shell Programming and Scripting

KSH SHELL: problem calculation number of lines inside compressed file

Hi Gurus, I am working with a korn shell script to simplify some operations of calculation number of lines inside compressed file. The called function (inside a cycle) is the following: ######################################### # F.ne: CheckCount #########################################... (3 Replies)
Discussion started by: GERMANICO
3 Replies

6. UNIX for Dummies Questions & Answers

How to use sed to copy specific lines from a file using shell variables?

hello! I am trying to use sed to copy specific set of lines from a file for which the starting and ending line numbers of the lines to be copied are stored in shell variables. How can i copy those lines? if the input_file is something like this and if the following is the script a=2 b=4... (4 Replies)
Discussion started by: a_ba
4 Replies

7. Shell Programming and Scripting

Change default shell of a specific user with awk

I would like to replicate the functionality of chsh (or passwd -e) by awk. This is what I got so far, but I think there should be an easier way to search and replace field $7 only for lines beginning with user_name: awk -v user_name="$user_name" -v new_shell="$new_shell" -F: '$1 == user_name {... (2 Replies)
Discussion started by: nomad84
2 Replies

8. Shell Programming and Scripting

How to change a number on a specific line with cshell or shell?

Hello all, I need to change a number in a file by adding some residuals respectively To make it clear, I need to add 0.11 to the number between 24-28 (which is below the SECON) for all the lines starting with FRR1 or I need to add 0.13 to the number between 24-28 (which is below the... (9 Replies)
Discussion started by: miriammiriam
9 Replies

9. Shell Programming and Scripting

To change Specific Lines in An XML file

hi Guys, this is my requirement, there is a huge xml file of this i have to change 3 lines with out opening the file /users/oracle > cat lnxdb-pts-454.xml|egrep "s_virtual|s_cluster|s_dlsnstatus" <cluster_port oa_var="s_clusterServicePort">9998</cluster_port> <host... (2 Replies)
Discussion started by: smarlaku
2 Replies

10. UNIX for Dummies Questions & Answers

Quick UNIX command to display specific lines in the middle of a file from/to specific word

This could be a really dummy question. I have a log text file. What unix command to extract line from specific string to another specific string. Is it something similar to?: more +/"string" file_name Thanks (4 Replies)
Discussion started by: aku
4 Replies

LEARN ABOUT SUSE

ascii

ASCII(7)						     Linux Programmer's Manual							  ASCII(7)

NAME

       ascii - the ASCII character set encoded in octal, decimal, and hexadecimal

DESCRIPTION

       ASCII  is  the  American  Standard  Code for Information Interchange.  It is a 7-bit code.  Many 8-bit codes (such as ISO 8859-1, the Linux
       default character set) contain ASCII as their lower half.  The international counterpart of ASCII is known as ISO 646.

       The following table contains the 128 ASCII characters.

       C program 'X' escapes are noted.

       Oct   Dec   Hex	 Char			     Oct   Dec	 Hex   Char
       ------------------------------------------------------------------------
       000   0	   00	 NUL ''		     100   64	 40    @
       001   1	   01	 SOH (start of heading)      101   65	 41    A
       002   2	   02	 STX (start of text)	     102   66	 42    B
       003   3	   03	 ETX (end of text)	     103   67	 43    C
       004   4	   04	 EOT (end of transmission)   104   68	 44    D
       005   5	   05	 ENQ (enquiry)		     105   69	 45    E
       006   6	   06	 ACK (acknowledge)	     106   70	 46    F
       007   7	   07	 BEL 'a' (bell)	     107   71	 47    G
       010   8	   08	 BS  '' (backspace)	     110   72	 48    H
       011   9	   09	 HT  '	' (horizontal tab)   111   73	 49    I
       012   10    0A	 LF  '
' (new line)	     112   74	 4A    J
       013   11    0B	 VT  'v' (vertical tab)     113   75	 4B    K
       014   12    0C	 FF  'f' (form feed)	     114   76	 4C    L
       015   13    0D	 CR  '
' (carriage ret)     115   77	 4D    M
       016   14    0E	 SO  (shift out)	     116   78	 4E    N
       017   15    0F	 SI  (shift in) 	     117   79	 4F    O
       020   16    10	 DLE (data link escape)      120   80	 50    P
       021   17    11	 DC1 (device control 1)      121   81	 51    Q
       022   18    12	 DC2 (device control 2)      122   82	 52    R
       023   19    13	 DC3 (device control 3)      123   83	 53    S
       024   20    14	 DC4 (device control 4)      124   84	 54    T
       025   21    15	 NAK (negative ack.)	     125   85	 55    U
       026   22    16	 SYN (synchronous idle)      126   86	 56    V
       027   23    17	 ETB (end of trans. blk)     127   87	 57    W
       030   24    18	 CAN (cancel)		     130   88	 58    X
       031   25    19	 EM  (end of medium)	     131   89	 59    Y
       032   26    1A	 SUB (substitute)	     132   90	 5A    Z
       033   27    1B	 ESC (escape)		     133   91	 5B    [
       034   28    1C	 FS  (file separator)	     134   92	 5C      '\'
       035   29    1D	 GS  (group separator)	     135   93	 5D    ]
       036   30    1E	 RS  (record separator)      136   94	 5E    ^
       037   31    1F	 US  (unit separator)	     137   95	 5F    _
       040   32    20	 SPACE			     140   96	 60    `
       041   33    21	 !			     141   97	 61    a
       042   34    22	 "			     142   98	 62    b
       043   35    23	 #			     143   99	 63    c
       044   36    24	 $			     144   100	 64    d
       045   37    25	 %			     145   101	 65    e
       046   38    26	 &			     146   102	 66    f
       047   39    27	 '			     147   103	 67    g
       050   40    28	 (			     150   104	 68    h
       051   41    29	 )			     151   105	 69    i
       052   42    2A	 *			     152   106	 6A    j
       053   43    2B	 +			     153   107	 6B    k
       054   44    2C	 ,			     154   108	 6C    l
       055   45    2D	 -			     155   109	 6D    m
       056   46    2E	 .			     156   110	 6E    n
       057   47    2F	 /			     157   111	 6F    o

       060   48    30	 0			     160   112	 70    p
       061   49    31	 1			     161   113	 71    q
       062   50    32	 2			     162   114	 72    r
       063   51    33	 3			     163   115	 73    s
       064   52    34	 4			     164   116	 74    t
       065   53    35	 5			     165   117	 75    u
       066   54    36	 6			     166   118	 76    v
       067   55    37	 7			     167   119	 77    w
       070   56    38	 8			     170   120	 78    x
       071   57    39	 9			     171   121	 79    y
       072   58    3A	 :			     172   122	 7A    z
       073   59    3B	 ;			     173   123	 7B    {
       074   60    3C	 <			     174   124	 7C    |
       075   61    3D	 =			     175   125	 7D    }
       076   62    3E	 >			     176   126	 7E    ~
       077   63    3F	 ?			     177   127	 7F    DEL

   Tables
       For convenience, let us give more compact tables in hex and decimal.

	  2 3 4 5 6 7	    30 40 50 60 70 80 90 100 110 120
	-------------	   ---------------------------------
       0:   0 @ P ` p	  0:	(  2  <  F  P  Z  d   n   x
       1: ! 1 A Q a q	  1:	)  3  =  G  Q  [  e   o   y
       2: " 2 B R b r	  2:	*  4  >  H  R    f   p   z
       3: # 3 C S c s	  3: !	+  5  ?  I  S  ]  g   q   {
       4: $ 4 D T d t	  4: "	,  6  @  J  T  ^  h   r   |
       5: % 5 E U e u	  5: #	-  7  A  K  U  _  i   s   }
       6: & 6 F V f v	  6: $	.  8  B  L  V  `  j   t   ~
       7: ' 7 G W g w	  7: %	/  9  C  M  W  a  k   u  DEL
       8: ( 8 H X h x	  8: &	0  :  D  N  X  b  l   v
       9: ) 9 I Y i y	  9: '	1  ;  E  O  Y  c  m   w
       A: * : J Z j z
       B: + ; K [ k {
       C: , < L  l |
       D: - = M ] m }
       E: . > N ^ n ~
       F: / ? O _ o DEL

NOTES

   History
       An ascii manual page appeared in Version 7 of AT&T UNIX.

       On older terminals, the underscore code is displayed as a left arrow, called backarrow, the caret is displayed as an up-arrow and the  ver-
       tical bar has a hole in the middle.

       Uppercase  and  lowercase  characters  differ by just one bit and the ASCII character 2 differs from the double quote by just one bit, too.
       That made it much easier to encode characters mechanically or with a non-microcontroller-based electronic keyboard  and	that  pairing  was
       found on old teletypes.

       The ASCII standard was published by the United States of America Standards Institute (USASI) in 1968.

SEE ALSO

       iso_8859-1(7), iso_8859-10(7), iso_8859-13(7), iso_8859-14(7), iso_8859-15(7), iso_8859-16(7), iso_8859-2(7), iso_8859-3(7), iso_8859-4(7),
       iso_8859-5(7), iso_8859-6(7), iso_8859-7(7), iso_8859-8(7), iso_8859-9(7)

COLOPHON

       This page is part of release 3.25 of the Linux man-pages project.  A description of the project, and information about reporting bugs,  can
       be found at http://www.kernel.org/doc/man-pages/.

Linux								    2009-02-12								  ASCII(7)
All times are GMT -4. The time now is 01:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy