04-24-2010
the line 1,1 is in output file becoz
i need all records from fille2 where the instance (of column 1) is not equql to the instances in file 1.
forex:
in file 1 we have two instances if 1 i.e 1,1 and 1,2
while in file 2 only one instance is found hence 1,1 is in output 2
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 there,
I have an csv file.
I want to compare the 16th and 18th columns. They contain alpha numeric characters. Some are same and some are different. We have to pick the ones which are different. But with certain rules.
16th col. 18th col.
---------- ... (1 Reply)
Discussion started by: sickboy
1 Replies
3. Shell Programming and Scripting
Hello,
I have the following problem:
There are two csv files
csv-file #1:
aaa1, aaa2, ... aaan
aaa1, bbb2, ... bbbn
aaa1, ccc2, ... cccn
bbb1, bbb2, ... bbbn
...
zzz1, zzz2, ... zzzn
csv-file #2:
aaa1, matchvalue1
ccc1, matchvalue2 (7 Replies)
Discussion started by: ghl10000
7 Replies
4. Shell Programming and Scripting
EDIT: My problems have been solved thanks to the help of bartus11 and pravin27
This code is just to help me learn. It serves no purpose other than that.
Here's a sample csv that I'm working with -
#listofpeeps.csv
Jackie Chan,1954,M
Chuck Norris,1930,M
Bruce Lee,1940,M
This code is... (13 Replies)
Discussion started by: chickeneaterguy
13 Replies
5. Shell Programming and Scripting
Hi!
I'm just new to shell scripting n simple tasks looks so tough in initial stage. i need to write a script which will read a property file, property file will be containing count of the csv files, and in a folder(same folder) there will be respective csv files.
like Property file
data1=100... (3 Replies)
Discussion started by: sukhdip
3 Replies
6. Shell Programming and Scripting
Hello,
I have about 10 csv files which range from csv1 - csv10.
Each csv file has same type/set of tabs and we have around 5-6 tabs for each of the csv file which have slightly different content(data).
A sample of CSV1 is shown below:
Joins: Data related to Joins, it can be any number of... (2 Replies)
Discussion started by: bobby1015
2 Replies
7. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
... (1 Reply)
Discussion started by: Naresh101
1 Replies
8. Shell Programming and Scripting
Hi All,
My requirement is to write a shell script to compare two large csv files.
I've created sample files for explaining my problem
i.e., a.csv and b.csv
contents of files:
-----------------
a.csv
------
Type,Memory (Kb),Location HD,Size (Mb),Serial #
XT,640,D402,0,MG0010... (2 Replies)
Discussion started by: vasavi
2 Replies
9. Shell Programming and Scripting
I have two csv files and im trying to compare them. e.g.
SAMPLE DATA:
file one:
ZipCode Name
20878 Washington
10023 Missouri
20304 Maryland
file two:
ID Name City ZipCode
11654 ... (11 Replies)
Discussion started by: dan139
11 Replies
10. UNIX for Beginners Questions & Answers
Hello all,
I have searched high and low for a solution to this, many have come really close but not quite what I'm after.
I have 2 files. One contains GUID's, for example:
8121E002-96FE-4C9C-BC5A-6AFF20DACECD
84468F30-F3B7-418B-81F0-0908E80792BF
A second file, contains a path to the... (8 Replies)
Discussion started by: tirmUK
8 Replies
LEARN ABOUT CENTOS
lpoptions
lpoptions(1) Apple Inc. lpoptions(1)
NAME
lpoptions - display or set printer options and defaults
SYNOPSIS
lpoptions [ -E ] [ -U username ] [ -h server[:port] ] -d destination[/instance] [ -o option[=value] ] ... [ -o option[=value] ]
lpoptions [ -E ] [ -U username ] [ -h server[:port] ] [ -p destination[/instance] ] -l
lpoptions [ -E ] [ -U username ] [ -h server[:port] ] [ -o option[=value] ] ... [ -o option[=value] ] [ -p destination[/instance] ] -r
option
lpoptions [ -E ] [ -U username ] [ -h server[:port] ] -x destination[/instance]
DESCRIPTION
lpoptions displays or sets printer options and defaults. lpoptions shows the default printer options when run with no arguments. Other
options include:
-E
Enables encryption when communicating with the CUPS server.
-U username
Uses an alternate username.
-d destination[/instance]
Sets the user default printer to destination. If instance is supplied then that particular instance is used. This option overrides the
system default printer for the current user.
-h server[:port]
Uses an alternate server.
-l
Lists the printer specific options and their current settings.
-o option[=value]
Specifies a new option for the named destination.
-p destination[/instance]
Sets the destination and instance, if specified, for any options that follow. If the named instance does not exist then it is created.
-r option
Removes the specified option for the named destination.
-x destination[/instance]
Removes the options for the named destination and instance, if specified. If the named instance does not exist then this does nothing.
If no options are specified using the -o option, then the current options for the named printer are reported on the standard output.
Options set with the lpoptions command are used by the lp(1) and lpr(1) commands when submitting jobs.
ROOT ACCOUNT OPTIONS
When run by the root user, lpoptions gets and sets default options and instances for all users in the /etc/cups/lpoptions file.
COMPATIBILITY
The lpoptions command is unique to CUPS.
FILES
~/.cups/lpoptions - user defaults and instances created by non-root users.
/etc/cups/lpoptions - system-wide defaults and instances created by the root user.
SEE ALSO
cancel(1), lp(1), lpadmin(8), lpr(1),
http://localhost:631/help
COPYRIGHT
Copyright 2007-2013 by Apple Inc.
29 August 2008 CUPS lpoptions(1)