Sponsored Content
Operating Systems Linux Ubuntu How to add a data column in existing file Post 302628003 by mahbub03 on Sunday 22nd of April 2012 06:41:40 PM
Old 04-22-2012
How to add a data column in existing file

Hi All

I need to add a column on my existing data file. I know similar posts are there but none of them were meeting my requirement. My input is

1.20 3.44 4.88
5.11 4.99 3.22
1.89 3.89 2.90


Desired output

1 1.20 3.44 4.88
2 5.11 4.99 3.22
3 1.89 3.89 2.90

I will highly appreciate your cordial help.

Thank you.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to add a line of data to already existing file in Unix..

Hello.. I have a text file with 100 lines of data. I need to add 1 line of data to that already existing file at the first line( beginning of the file) , so that the already existing 100 lines will start from 2 nd line.Now the file will have 101 lines of data. Help me on how to add the line... (4 Replies)
Discussion started by: charan81
4 Replies

2. Shell Programming and Scripting

how to add a new column in an existing file

Hi guys, Please help me if u have some solution. I have a file with three columns separated by ':' - INPUT_FILE C416722_2 : calin Dirigent : Dirigent AC4174_6 : Jac : cal_co TC4260_5 : [no : lin kite BC426302_1 : [no : calin Dirigent lin JC426540_3 : lin Pymo_bin : calin TC428_3 : no7... (4 Replies)
Discussion started by: sam_2921
4 Replies

3. UNIX for Dummies Questions & Answers

Add line with data to existing file

i have a file called motors with 3 columns separated with tabs eg: car make reg i want to create a executable file that will add a line with data eg: car make reg benz s600 t35778 can you please show me how to do this? (7 Replies)
Discussion started by: fletcher
7 Replies

4. Shell Programming and Scripting

add more data to existing data in a file

Hi all, I need help to add additional data from file2 to existing data in file 1 using awk, sed or perl. the ID in file 1 should match against field $3 in file2 file1 #this is a new game ID HR_1 BASE1 30 BASE2 37 DETAIL No TYPE L @@ ID HR_10 BASE1 6030 BASE2 ... (4 Replies)
Discussion started by: redse171
4 Replies

5. Shell Programming and Scripting

Add new column from another file in existing file

I have two files which has one column comman in them. The two files has exact same number of rows in the same sequence. I want to add the second column of Users_detail_servicesonly.txt as last column in the existing file. 1) Users_detail_complete.txt V0135 Memb Info ... (4 Replies)
Discussion started by: Sanjeev Yadav
4 Replies

6. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

7. Shell Programming and Scripting

Increment existing column in file

Hi All, I have a file with 3 millions records in which 3rd column is same throughout say its value is 0 throughout.for example: Col1 Col2 Col3 Col4 A 1 0 5 B 2 0 6 C 3 0 7 D 4 0 9 I want my output as : Col1 Col2 Col3 Col4 A 1 ... (4 Replies)
Discussion started by: Pinky456
4 Replies

8. Shell Programming and Scripting

Help with add existing file name as new data column in new output file

Input File 1 cat S1.txt MI0043 2731 miR-1 Input File 2 cat S4.txt MI006 310 CiR-1 MI057 10 CiR-24 MI750 5 CiR-24 Desired Output File 1 cat S1.txt.out MI0043 2731 miR-1 S1.txt Desired Output File 2 cat S4.txt.out MI006 310 CiR-1 S4.txt (3 Replies)
Discussion started by: perl_beginner
3 Replies

9. Shell Programming and Scripting

Matching column then append to existing File as new column

Good evening I have the below requirements, as I am not an experts in Linux/Unix and am looking for your ideas how I can do this. I have file called file1 and file2. I need to get the second column which is text1_random_alphabets and find that in file 2, if it's exists then print the 3rd... (4 Replies)
Discussion started by: mychbears
4 Replies

10. Shell Programming and Scripting

Add current time stamp column in existing csv file

Hi , I want to add a new column 'current_time stamp' in my existing csv file with current time stamp for all the records.I tried something this but this is printing 0 with date & time and printed date one line above header.Please help awk -F "," 'BEGIN{ OFS="," } {$6=system("date... (5 Replies)
Discussion started by: netdbaind
5 Replies
BLAZE-LIST(1)						    BlazeBlogger Documentation						     BLAZE-LIST(1)

NAME
blaze-list - lists blog posts or pages in the BlazeBlogger repository SYNOPSIS
blaze-list [-cpqrsCPSV] [-b directory] [-I id] [-a author] [-t title] [-T tag] [-d day] [-m month] [-y year] [-n number] blaze-list -h|-v DESCRIPTION
blaze-list lists existing blog posts or pages in the BlazeBlogger repository. Additionally, it can also display basic repository statistics. OPTIONS
-b directory, --blogdir directory Allows you to specify a directory in which the BlazeBlogger repository is placed. The default option is a current working directory. -I id, --id id Allows you to display a single blog post or a page with the specified id. -a author, --author author Allows you to list blog posts or pages by the selected author. -t title, --title title Allows you to list blog posts or pages with matching title. -T tag, --tag tag Allows you to list blog posts or pages with matching tag. -d day, --day day Allows you to list blog posts or pages from the specified day of a month. The value has to be in the "DD" form. -m month, --month month Allows you to list blog posts or pages from the specified month. The value has to be in the "MM" form. -y year, --year year Allows you to list blog posts or pages from the specified year. The value has to be in the "YYYY" form. -n number, --number number Allows you to specify a number of blog posts or pages to be listed. -p, --page Tells blaze-list to list pages. -P, --post Tells blaze-list to list blog posts. This is the default option. -S, --stats Tells blaze-list to display statistics. -s, --short Tells blaze-list to display each blog post or page information on a single line. -r, --reverse Tells blaze-list to display blog posts or pages in reverse order. -c, --color Enables colored output. When supplied, this option overrides the relevant configuration option. -C, --no-color Disables colored output. When supplied, this option overrides the relevant configuration option. -q, --quiet Disables displaying of unnecessary messages. -V, --verbose Enables displaying of all messages. This is the default option. -h, --help Displays usage information and exits. -v, --version Displays version information and exits. EXAMPLE USAGE
List all blog post: ~]$ blaze-list ID: 11 | 2010-07-05 | Jaromir Hradilek Title: Join #blazeblogger on IRC Tags: announcement ID: 10 | 2009-12-16 | Jaromir Hradilek Title: Debian and Fedora Packages Tags: announcement etc. List all blog post in reverse order: ~]$ blaze-list -r ID: 1 | 2009-02-10 | Jaromir Hradilek Title: BlazeBlogger 0.7.0 Tags: release ID: 2 | 2009-02-11 | Jaromir Hradilek Title: BlazeBlogger 0.7.1 Tags: release etc. List all pages: ~]$ blaze-list -p ID: 5 | 2009-02-10 | Jaromir Hradilek Title: Downloads ID: 4 | 2009-02-10 | Jaromir Hradilek Title: Themes etc. List each blog post on a single line: ~]$ blaze-list -s ID: 11 | 2010-07-05 | Join #blazeblogger on IRC ID: 10 | 2009-12-16 | Debian and Fedora Packages etc. Display a short version of blog statistics: ~]$ blaze-list -Ss There is a total number of 11 blog posts and 5 pages in the repository. SEE ALSO
blaze-config(1), blaze-add(1) BUGS
To report a bug or to send a patch, please, add a new issue to the bug tracker at <http://code.google.com/p/blazeblogger/issues/>, or visit the discussion group at <http://groups.google.com/group/blazeblogger/>. COPYRIGHT
Copyright (C) 2009-2011 Jaromir Hradilek This program is free software; see the source for copying conditions. It is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Version 1.2.0 2012-03-05 BLAZE-LIST(1)
All times are GMT -4. The time now is 04:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy