11-25-2009
thegeek;
It works. Thank you. Now, I'm trying to use grep to fetch only the columns from file 1 (now that has a column no. header) with the column numbers listed in file2:
file="file2"
while read line
do
grep $line file1 >> file4
done < $file
But this code does not work, it gives me an even bigger file than file1, it should be much more smaller.
Last edited by sogi; 11-26-2009 at 03:41 AM..
Reason: the code is not displaying as code
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hey..
I'm writing a code to download some stuff from Informix database and put it on Xls. It works fine, but I have a problem fitting in a new requirement.
I have currently a file which has information like below.
f_name|Ronnie|Johnson|23.00|
f_sal|Ronnie|Jhonson|4000.00|... (4 Replies)
Discussion started by: rosh0623
4 Replies
2. Shell Programming and Scripting
Hi
I have the following info in a file file1
ABCD
DSFD
sdfsd
YUISA
I want to add a column to the file file1 like the below.
STR ABCD
STR DSFD
STR sdfsd
STR YUISA
Is there any way in sed or awk to do it.
Regards
Dhana (7 Replies)
Discussion started by: dhanamurthy
7 Replies
3. Shell Programming and Scripting
Dear all,
I have a file created in the name sample.txt in UNIX with header and footer. How to insert a required string (for example "FILE1") in the header part after the file has been created. What kind of command can i use to do the same.
Thanks in advance
Hari (3 Replies)
Discussion started by: Hari123
3 Replies
4. Shell Programming and Scripting
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
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. Shell Programming and Scripting
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
7. Shell Programming and Scripting
Need your help in appending header(file1 contains header ) to my file2. I am using KSH AIX OS.
I know how to do with taking temporary files.
cat file1 >temp
cat file2 >>temp
mv temp file2
Is there way to append directly to a file in ksh.
I don't find Sed -i option on my... (10 Replies)
Discussion started by: gvkumar25
10 Replies
8. Shell Programming and Scripting
How to find total number of special character in a column?
I am using awk -f "," '$col_number "*$" {print $col_number}' file.csv|wc -l but its not giving correct output. It's giving output as 1 even though i give no special character?
Please use code tags next time for your code and... (4 Replies)
Discussion started by: AjitKumar
4 Replies
9. UNIX for Beginners Questions & Answers
I would like to hear your directions on how to Insert theses tag </TITLE> and <TEXT> at a given position in 1000 of text files.
My Files look like as
samplefile1.txt
<DOC>
<DOCNO>3_September_2012</DOCNO>
<TITLE>
... ... ... .... ... .. .. .. ... .. .. ....
</TITLE>
<TEXT>
.... (1 Reply)
Discussion started by: imranrasheedamu
1 Replies
10. Shell Programming and Scripting
Hi,
I am trying to insert header row with a special character delimiter with Unicode u0109 into a file with ‘echo’, header looks like below
echo –e “header1\u0109header\u0109header3\u0109header4”
It just inserting as it is in the quotes but not the special character, Please suggest if am... (2 Replies)
Discussion started by: oom
2 Replies
PASTE(1) General Commands Manual PASTE(1)
NAME
paste - paste multiple files together
SYNOPSIS
paste [-s] [-d list] file...
OPTIONS
-d Set delimiter used to separate columns to list.
-s Print files sequentially, file k on line k.
EXAMPLES
paste file1 file2 # Print file1 in col 1, file2 in col 2
paste -s f1 f2 # Print f1 on line 1 and f2 on line 2
paste -d : file1 file2
# Print the lines separated by a colon
DESCRIPTION
Paste concatenates corresponding lines of the given input files and writes them to standard output. The lines of the different files are
separated by the delimiters given with the option -s. If no list is given, a tab is substituted for every linefeed, except the last one.
If end-of-file is hit on an input file, subsequent lines are empty. Suppose a set of k files each has one word per line. Then the paste
output will have k columns, with the contents of file j in column j. If the -s flag is given, then the first file is on line 1, the second
file on line 2, etc. In effect, -s turns the output sideways.
If a list of delimiters is given, they are used in turn. The C escape sequences
, , \, and are used for linefeed, tab, backslash,
and the null string, respectively.
PASTE(1)