06-18-2008
Awesome!!! it works..Thnks a lot pal..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I've two .csv files as below
file1.csv
abc, tdf, 223, tpx
jgsd, tex, 342, rpy
a, jdjdsd, 423, djfkld
Where as file2.csv is the new version of file1.csv with some added fields in the end of each line and some additional lines.
lfj, eru, 98, jkldj, 39, jdkj9
abc, tdf, 223, tpx,... (3 Replies)
Discussion started by: ganapati
3 Replies
2. Shell Programming and Scripting
hi,
i have 1 files a.csv temp.out
a.cvs looks like
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-209
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-219
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-220
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-221
and temp.out looks... (1 Reply)
Discussion started by: raghavendra.cse
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a comma delimited file that contains name, account number, and account date/time(example record below). I want to pull off all the records that have an account date greater than 8/1 of the current year, and create a new file with those records. So for this year, it would take... (6 Replies)
Discussion started by: keeferb
6 Replies
4. Shell Programming and Scripting
Hi all,
I have two large files and i want a field by field comparison for each record in it.
All fields are tab seperated.
file1:
Email SELVAKUMAR RAMACHANDRAN
Email SHILPA SAHU
Web NIYATI SONI
Web NIYATI SONI
Email VIINII DOSHI
Web RAJNISH KUMAR
Web ... (4 Replies)
Discussion started by: Suman Singh
4 Replies
5. Shell Programming and Scripting
I've two files with data like below:
file1.txt:
AAA,Apples,123
BBB,Bananas,124
CCC,Carrot,125
file2.txt:
Store1|AAA|123|11
Store2|BBB|124|23
Store3|CCC|125|57
Store4|DDD|126|38
So,the field separator in file1.txt is a comma and in file2.txt,it is |
Now,the output should be... (2 Replies)
Discussion started by: asyed
2 Replies
6. Shell Programming and Scripting
First, thanks for the help in previous posts... couldn't have gotten where I am now without it!
So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following:
If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies
7. Shell Programming and Scripting
Hello;
i have 2 file that each of them contain many records such as below:
file1
2006/01/01 12:36:49.3 37.902 48.482 0.0 1136119009
2006/01/01 13:16:22.9 34.933 46.292 2.0 1136121382
2006/01/01 13:54:33.2 37.762 48.163 18.8 1136123673
2006/01/01 14:32:9.1 37.739 48.330... (2 Replies)
Discussion started by: saeed.soltani
2 Replies
8. Shell Programming and Scripting
I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be compared against and if it is same then append field 5.
i.e from
ANG SJ,0,B,LC22,LC22(0)
BAT... (2 Replies)
Discussion started by: nike27
2 Replies
9. Programming
I am having hard time with this sql:
select partition_name, high_value
FROM user_tab_partitions
WHERE table_name = 'WNP_TPRESPONSE_INSTANCE'
and to_char(high_value) <= to_char(sysdate - 15, 'yyyymm')
;
I get an error: ORA-00932: inconsistent datatypes: expected CHAR got LONG... (1 Reply)
Discussion started by: mrn6430
1 Replies
10. Shell Programming and Scripting
I have two files : file1 and file2
file1 format:
7026-H70 7026-1017685
7026-H70 7026-1017687
7026-B80 7026-108D65A
7026-B80 7026-108D67A
7046-B50 7026-1034B4A
File2 format :
mt01cp01 7026-B80 01108D69A
mt01cp02 7026-B80 01108D68A
mt01sv01 7046-B50... (7 Replies)
Discussion started by: amir07
7 Replies
LEARN ABOUT DEBIAN
bntext
bntext(5) File Formats Manual bntext(5)
NAME
bnmotd.txt, bnnews.txt bnissue.txt - messages for the Unix Battle.net daemon
DESCRIPTION
The file bnmotd.txt contains text displayed by bnetd(1), when users first log into the server.
The file bnnews.txt contains text displayed when the user uses the /news chat command.
The files consist of raw text with printf-style formatting escapes. Each line of a file can contain a type formatter from the following
list:
%B Use the broadcast attribute (???).
%C Execute the line as if the user entered it as a command.
%E Use the error attribute (red).
%I Use the info attribute (yellow). This is the same was %W.
%M Normal chat message (white). This will appear as if the user said it.
%T Emote chat message (???). This will appear as if the user said it.
%W Use the warning attribute (yellow). This is the same was %I.
Within a line, any of the following format formatters may be used:
%% Expand to a literal percent sign (%).
%a Expand to the number of accounts on the server.
%c Expand to the number of channels on the server. This includes all permanent and current temporary channels.
%g Expand to the number of games on the server. This includes both public and private (passworded) games.
%h Expand to the hostname of the server (as returned by gethostname(2)).
%i Expand to this user's account ID number, formatted with a leading pound (#) sign and leading zeros.
%l Expand to this user's current chat name which is usually the same
%r Expand to the IP of the remote machine (the client).
%t Expand to four character client tag.
%u Expand to the number of users logged into the server.
%v Expand to the version number of the server.
SEE ALSO
bnetd(1)
AUTHOR
Ross Combs (ross@bnetd.org)
2 August, 2001 bntext(5)