Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed/awk-adding numeric to a column
Top Forums Shell Programming and Scripting sed/awk-adding numeric to a column Post 302383434 by gubbu on Tuesday 29th of December 2009 07:26:53 PM
Old 12-29-2009
sed/awk-adding numeric to a column
I have a txt file as follows

Code:
Oct 1 file1 4144
Oct 1 file23 5170
Oct 2 file5 3434
Oct 21 file56 2343

I need to add a new column by marking the right log file from current directory. For example populate like this. Please not in the second columt for "1" it has associated log file as "01"

Oct 1 file1 4144 server.log.2009-10-01
Oct 1 file23 5170 server.log.2009-10-01
Oct 2 file5 3444 server.log.2009-10-02
Oct 2 file5 3234 server.log.2009-10-02
Oct 2 file5 3534 server.log.2009-10-02
Oct 20 file5 3434 server.log.2009-10-20
Oct 21 file56 2343 server.log.2009-10-21

I am hoping this can be easily done with SED ?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

problem while adding column values in awk

Hi, I have a file "input.txt" with the following content : 5312,0,,,1,8,141.2,20090727 3714,0,,,1,8,285.87,20090727 5426,0,,,1,8,3.9,20090727 3871,0,,,1,8,30.4,20090727 9071,0,,,1,8,146.2,20090727 5141,0,,,1,8,2.8,20090727 0460,0,,,1,8,-0.1,20090727 7918,0,,,1,8,-0.1,20090727... (3 Replies)
Discussion started by: valokv
3 Replies

2. Shell Programming and Scripting

awk-adding a column to a file

Hello Friends, i used awk to sum up total size of files under a directory (with the help of examples, threads here). ls -l | awk '/^-/ {total += $5} END {printf "%15.0f\n",total}' >> total.txt After each execution of the script total result is appended into a text file: 7010 7794 8890 ... (7 Replies)
Discussion started by: EAGL€
7 Replies

3. Shell Programming and Scripting

Awk , Sed Print last 4 numeric characters

Hello All, I have been searching and trying this for a bit now. Can use some assistance. Large 5000 line flat file. bash, rhel5 Input File Sinppet: Fri Oct 30 09:24:02 EDT 2009 -- 1030 Fri Oct 30 09:26:01 EDT 2009 -- 73 Fri Oct 30 09:28:01 EDT 2009 -- 1220 Fri Oct 30 09:30:01 EDT... (9 Replies)
Discussion started by: abacus
9 Replies

4. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Is there anyway to use awk to add a first column to my data that automatically goes from 1 to n , where n is the numbers of my rows?:confused: (4 Replies)
Discussion started by: cosmologist
4 Replies

5. Shell Programming and Scripting

Adding column using awk

Hello everyone, I have a file with the following structure: abc xyz 111 222 agf hjhf 787 799 tht yah 878 898 ... ... ... ... ... ... ... ... ... ... ... ... I want to add a column (with a fixed value of 1000) at the end such that it becomes: abc xyz 111 222 1000 agf hjhf 787... (5 Replies)
Discussion started by: ad23
5 Replies

6. Linux

Adding a prefix to a column using awk/sed commands

Hello, I am a newbie to linux and struggling to find a better way to append a column in a text file. Here is the file i want to modify: It has 8 columns (and thousands of rows). I want to append the first column by adding "chr" infront of the numbers. Some rows have a string in the first... (4 Replies)
Discussion started by: bjorngill
4 Replies

7. UNIX for Dummies Questions & Answers

Adding Filename as column using sed

Hi , Can any one please tell me, how can we add the file name as column using sed. right now we are using the below awk command for adding the file name as column but when we are calling this script from datastage it is deleting the file data..very weird raised a support ticket with datastage.... (2 Replies)
Discussion started by: mora
2 Replies

8. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830... (3 Replies)
Discussion started by: ryran
3 Replies

9. Shell Programming and Scripting

Adding a specified value to a specified column - awk?

Hi everyone! I sometimes need to do some simple arithmetics, like adding a number to a certain column of a file. So I wrote a small function in the .bashrc file, which looks like this shifter() { COL=$1 VAL=$2 FILE=$3 cp $FILE $FILE.shifted awk 'NF==4 {$(( $COL )) = $(( $COL ))... (6 Replies)
Discussion started by: radudownload
6 Replies

10. UNIX for Dummies Questions & Answers

awk adding counts together from column

Hello Im new treat me nicely, I have a headache :) I have a script that seemed to work now it doesnt anyway, the last part is adding counts of unique items in a csv file eg 05492U34 38 05492U34 47 two columns, (many different values like this in file) i want... (7 Replies)
Discussion started by: aniquebmx
7 Replies

LEARN ABOUT OSF1

fdmns

fdmns(4)						     Kernel Interfaces Manual							  fdmns(4)

NAME

       fdmns - contains file domain names and devices

DESCRIPTION

       The  fdmns directory ensures access to file domains by providing symbolic links to every volume in the file domain.  The mkfdmn, rmvol, and
       addvol utilities automatically manage the fdmns directory.  Each file domain is described by its own subdirectory within the  fdmns  direc-
       tory.

       Back  up  the fdmns directory structure regularly using the vdump utility or any other backup utility (dump, tar, cpio). If the contents of
       the fdmns directory are deleted or corrupted, restore the directory from your most recent backup tape.  You must  also  restore	the  fdmns
       directory after installing a new version of the operating system.

       Always  keep  a hardcopy record of each file domain and its associated volumes in case a backup copy of the fdmns directory is unavailable.
       If you have a record, you can reconstruct the fdmns directory structure. The following is a sample fdmns directory:

       total 2 drwxr-x---     2 root	system	  512 Nov 24 18:35 scratch/ drwxr-xr-x	   2 root    system    512 Nov 24 18:35 usr/

	./scratch: total 0 lrwxr-x---	  1 root    system    10 Oct 23 15:13 dsk10c@ ->  /dev/disk/dsk10c  lrwxr-x---	   1  root    system	10
       Oct 24 11:33 dsk11c@ -> /dev/disk/dsk11c lrwxr-x---     1 root	 system     9 Oct 13 18:29 dsk8c@ -> /dev/disk/dsk8c

	./usr:	total  0 lrwxr-x---	1 root	  system     9 Oct 24 10:52 dsk2g@ -> /dev/disk/dsk2c lrwxr-x---     1 root    system	  9 Nov 24
       10:35 dsk9c@ -> /dev/disk/dsk9c

RESTRICTIONS

       Do not remove or modify the contents of this directory.	If the fdmns file becomes corrupted, you can no longer access (or mount) any file-
       set in the file domains.

SEE ALSO

       advfs(4), vdump(8), mkfdmn(8), vrestore(8), showfdmn(8)

																	  fdmns(4)
All times are GMT -4. The time now is 02:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy