I'm new hear and a noob regarding file editing and awk, but I have a file that has one column and i want to add a new column, as the first column and it have the same data in the column.
ex: file1 -
Code:
123456
654321
098765
567890
here is what i want my file to look like (tab deliminator):
Code:
GA 123456
GA 654321
GA 098765
GA 567890
Here is what i was working with but it's not work.
Code:
awk '{print "GA",$0}' file.txt > test.out
Code:
awk '{print "GA" \t $0}' file.txt > test.out
Help.
Moderator's Comments:
Code tags for code, please.
Last edited by Corona688; 06-22-2012 at 01:47 PM..
hi! I am a newbee. I would really appreciate if you can answer the following question:
I have a huge data file, 214MB with several coloumns. I need to delete the very last line of the file. Everything I know takes a lot of time to do it ( because I have to open the file in an editor or run a... (3 Replies)
Hi,
I am in a situation wherein am getting file file certailn values
suppose
1u56979hhghhklklkkkjkjkjk 0 0 0
The file will have values like above only.
I need to add another field of NULL value(of length 9) at the end of first column i.e.
It should like this after editing:... (4 Replies)
I have created a file with vi -x (file name) this is encrypted file when i again open this file it ask me to enter a password before editing it.Can i remove this password but i don't want to delete a file how to do this.
Thanks (0 Replies)
Hi all,
I have a file with following contents
# rad124
# radkus
# raddebug
# radtrace
I could like to remove the # and space present before the key word "rad".
Any ways to do this using "subsitution method(:%s/old/new/g)" will be hepful. (1 Reply)
Hi,
I am having a file which is fix length and comma seperated. And I want to replace values for one column.
I am reading file line by line in variable $LINE and then replacing the string.
Problem is after changing value and writing new file temp5.txt, formating of original file is getting... (8 Replies)
I have a text file that has data like:
Data "12345#22"
Fred
ID 12345
Age 45
Wilma
Dino
Data "123#22"
Tarzan
ID 123
Age 33
Jane
I need to figure out a way of adding 1,000,000 to the specific lines (always same format) in the file, so it becomes:
Data "1012345#22"
Fred
ID... (16 Replies)
I have a file which has 10 million records in it. When am trying to edit the file with vi, the following error occurs:
~
~
~
~
~
~
~
~
"file1" Value too large for defined data type
Is there any way that I can edit this file without using vi? Any help would be really appreciated.... (8 Replies)
Hi All,
I've to edit the below file in the
Current File:
XXX
Rows found with null for one or more non-nullable columns in the source table
SELECT
COUNT(*)
FROM
(
SELECT
1 as one
FROM
datum
WHERE:wall:
datum.ID IS NULL
)
a (1 Reply)
Dear Guru's
I'm using Putty and want to edit a file. I know we generally use vi editor to do it. As I'm not good in using vi editor, I want to convert the vi into something like text pad. Is there any option in Putty to do the same ? Thanks for your response.
Srini (6 Replies)
Discussion started by: thummi9090
6 Replies
LEARN ABOUT LINUX
colrm
COLRM(1) BSD General Commands Manual COLRM(1)NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO awk(1), column(1), cut(1), paste(1)HISTORY
The colrm command appeared in 3.0BSD.
BSD August 4, 2004 BSD
06-22-2012
