Sponsored Content
Top Forums Shell Programming and Scripting Replace a column with a value by ignoring the header lines Post 302785251 by aravindj80 on Monday 25th of March 2013 06:45:26 AM
Old 03-25-2013
Thanks Anbu

Hello Thanks Anbu,

the f1.gz output is slightly modified , the script given by is working if there is no space after comma.

gzcat f1.gz | more

< Aravind, 33, chennai, 09091980, , , , , , , surfing>
< Swapnil, 32, bhopal, 01121981, , , , , , , cricket>

after comma there is space . how to modify the code for the same.

one more thing is it possible to recreate output with the same file name with changes in the code :-)

if yes please tell the same it would be of great help.

Last edited by aravindj80; 03-25-2013 at 08:06 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to count lines - ignoring blank lines and commented lines

What is the command to count lines in a files, but ignore blank lines and commented lines? I have a file with 4 sections in it, and I want each section to be counted, not including the blank lines and comments... and then totalled at the end. Here is an example of what I would like my... (6 Replies)
Discussion started by: kthatch
6 Replies

2. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

3. UNIX for Dummies Questions & Answers

deleteing duplicate lines sing uniq while ignoring a column

I have a data set that has 4 columns, I want to know if I can delete duplicate lines while ignoring one of the columns, for example 10 chr1 ASF 30 15 chr1 ASF 20 5 chr1 ASF 30 6 chr2 EBC 15 4 chr2 EBC 30 ... I want to know if I can delete duplicate lines while ignoring column 1, so the... (5 Replies)
Discussion started by: japaneseguitars
5 Replies

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

6. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Friends, I need help with the following in UNIX. Merge all csv files in one folder considering only 1 header row and ignoring header of all other files. FYI - All files are in same format and contains same headers. Thank you (4 Replies)
Discussion started by: Shiny_Roy
4 Replies

7. Shell Programming and Scripting

Add column header and row header

Hi, I have an input like this 1 2 3 4 2 3 4 5 4 5 6 7 I would like to count the no. of columns and print a header with a prefix "Col". I would also like to count the no. of rows and print as first column with each line number with a prefix "Row" So, my output would be ... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

8. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies

9. UNIX for Beginners Questions & Answers

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy... (10 Replies)
Discussion started by: Kunalcurious
10 Replies

10. Shell Programming and Scripting

Find header in a text file and prepend it to all lines until another header is found

I've been struggling with this one for quite a while and cannot seem to find a solution for this find/replace scenario. Perhaps I'm getting rusty. I have a file that contains a number of metrics (exactly 3 fields per line) from a few appliances that are collected in parallel. To identify the... (3 Replies)
Discussion started by: verdepollo
3 Replies
fastmail(1)						      General Commands Manual						       fastmail(1)

NAME
fastmail - quick batch mail interface SYNOPSIS
bcc-list] cc-list] comments] from-name] from-addr] in-reply-to] reply-to] references] subject] filename address-list DESCRIPTION
The command is a simple interface to the mail system that allows you to send a message without the overhead of an interactive mailer. It is particularly efficient in batch-processing mail to very large groups of people. All addresses should be full e-mail addresses, aliases in the file, or local login names. Options recognizes the following options: Include a header entry. Send blind carbon copies to the comma-separated list of addresses in bcc-list. Include a header entry. Send carbon copies to the comma-separated list of addresses in cc-list. Include a header entry with the string value comments. Debug. Display information on processing steps. Replace the user name in the header entry with from-name. If the user is and the user name is then the default line is: The option changes it to: Replace the address in the header entry with from-addr. In the example above, changes the original entry to Include the header entry with the string value in-reply-to. This is usually used to identify a message that you are replying to. Include the header entry with the single address given in replyto. This is the address where replies will usually be sent, instead of to the address given in the header entry, very common with mailing lists. Include a header entry containing the string value references. Include a header entry containing the value subject. If this option is omitted, the message is sent without a subject entry. Operands recognizes the following operands: address-list A list of one or more blank-separated addresses for the header line. These are the principal recipients of the mes- sage. filename Either the name of a file containing the message, or a dash to read from standard input. EXAMPLES
A Fully Specified Command This command has every option specified. The online execution displays the following debug messages: The received message has the following relevant header entries: The header entry is not transmitted. A Batch Process Suppose you are user on machine and you have a shell script named that contains the following lines: The command: would mail a copy of the file to and staggered ten seconds apart. would also silently receive a copy of the first message in the mail. Each resultant message would include the header lines: FILES
aliases file. Mail transport agent. Temporary file. AUTHOR
was developed by HP. SEE ALSO
elm(1), sendmail(1M). RFC 822 "Standard for the Format of Internet Text Messages" fastmail(1)
All times are GMT -4. The time now is 03:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy