Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Inserting a field without disturbing field separator on other fields
Top Forums Shell Programming and Scripting Inserting a field without disturbing field separator on other fields Post 302973071 by RudiC on Friday 13th of May 2016 01:48:16 PM
Old 05-13-2016
If you're very sure there's no empty fields in your file, try

Code:
awk '
FNR == NR       {P[NR] = $0
                 next
                }
FNR == 1        {FN++
                }
                {printf "%s", $1 > ("output" FN)
                 $19 = P[FN] FS $19
                 $0 = $0
                 for (i=2; i<=NF; i++) printf "%7s", $i > ("output" FN)
                 printf RS > ("output" FN)
                }

' nawk7 file1 file1 file1 file1 file1
cf out*
output1:
032016002  2.891 97.109 16.605 27.172 24.017 32.207  0.233  0.021 39.810  0.077  0.026 19.644 13.882  0.131 11.646  0.102 11.449  2.979 76.265 23.735 . . . 
output2:
032016002  2.891 97.109 16.605 27.172 24.017 32.207  0.233  0.021 39.810  0.077  0.026 19.644 13.882  0.131 11.646  0.102 11.449  3.078 76.265 23.735  . . . 
output3:
032016002  2.891 97.109 16.605 27.172 24.017 32.207  0.233  0.021 39.810  0.077  0.026 19.644 13.882  0.131 11.646  0.102 11.449  2.980 76.265 23.735  . . . 
output4:
032016002  2.891 97.109 16.605 27.172 24.017 32.207  0.233  0.021 39.810  0.077  0.026 19.644 13.882  0.131 11.646  0.102 11.449  1.338 76.265 23.735  . . . 
output5:
032016002  2.891 97.109 16.605 27.172 24.017 32.207  0.233  0.021 39.810  0.077  0.026 19.644 13.882  0.131 11.646  0.102 11.449  3.272 76.265 23.735  . . .

This User Gave Thanks to RudiC For This Post:
am24
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to include field separator if there are blank fields?

Hi, I have the following data in the format as shown (note: there are more than 1 blank spaces between each field and the spaces are not uniform, meaning there can be one blank space between field1 and field2 and 3 spaces between field3 and field4, in this example, # are the spaces in between... (19 Replies)
Discussion started by: ReV
19 Replies

2. Shell Programming and Scripting

Sorting on two fields time field and number field

Hi, I have a file that has data in it that says 00:01:48.233 1212 00:01:56.233 345 00:09:01.221 5678 00:12:23.321 93444 The file has more line than this but i just wanted to put in a snippet to ask how I would get the highest number with time stamp into another file. So from the above... (2 Replies)
Discussion started by: pat4519
2 Replies

3. Shell Programming and Scripting

Field separator in awk

Hi I need to check if field separator I am using in awk statement is " : ", for example: TIME=12:59 HOUR=`echo "$TIME" | awk '{FS=":"; print $1}'` MINUTES=`echo "$TIME" | awk '{FS=":"; print $2}'` Is there a way to check within the above awk statement ? Thanks for help -A (2 Replies)
Discussion started by: aoussenko
2 Replies

4. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies

5. Shell Programming and Scripting

Field separator X'1F'

Hi, I have a flat file with fields separated by a X'1F' i have to fetch 4th field from second line. please help me how to achieve it. I tried with below command and its not working. cut -f4 -d`echo -e '\x1f'` filename.txt I am using SunOS. Thanks in advance. (2 Replies)
Discussion started by: rohan10k
2 Replies

6. Shell Programming and Scripting

echo field separator

I am trying to echo all fields except for the last field. I want to include the field seperator, but it is removed. echo "a;s;v;g" | awk -F ";" '{$(NF--)=""; print}' a s v I want an output like this: a;s;v; (3 Replies)
Discussion started by: locoroco
3 Replies

7. Shell Programming and Scripting

Inserting a new field inbetween two exisitng field

I have a '|' delimited file. My file looks like below 23|nationalhoilday|feb12||||||||||||||california|northdistrict|| In the same way, each record has 164 fields. I have to insert one more field after the 85th field. Expected output... (3 Replies)
Discussion started by: machomaddy
3 Replies

8. UNIX for Dummies Questions & Answers

change field separator only from nth field until NF

Hi ! input: 111|222|333|aaa|bbb|ccc 999|888|777|nnn|kkk 444|666|555|eee|ttt|ooo|ppp With awk, I am trying to change the FS "|" to "; " only from the 4th field until the end (the number of fields vary between records). In order to get: 111|222|333|aaa; bbb; ccc 999|888|777|nnn; kkk... (1 Reply)
Discussion started by: beca123456
1 Replies

9. Shell Programming and Scripting

awk field separator help -

Hi Experts , file : - How to construct the awk filed separator so that $1, $2 $3 , can be assigned to the each "" range. I am trying : awk -F"]" '{print $1}' but it is printing the entire file. Not first field. The desired output needed for first field... (9 Replies)
Discussion started by: rveri
9 Replies

10. Shell Programming and Scripting

Field separator

Hello All, I have a file, but I want to separate the file at a particular record with comma"," in the line Input file APPLE6SSAMSUNGS5PRICEPERPIECEDOLLAR600EACH010020340URX581949695US to Output file APPLE6S,SAMSUNGS5,PRICEPERPIECE,DOLLAR600EACH,010020340URX581949695,US This is for... (11 Replies)
Discussion started by: m6248m
11 Replies

LEARN ABOUT LINUX

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.27 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 05:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy