10-27-2010
Help on sed requested
Hi
I have a problem to resolve, I think sed is the best option, and I am not successful yet.
Have a UNIX file which has records as of the 2 character state codes like
NY
NJ
PA
DE
From the file I need to create this as a variable in the same script or another file - ('NY','NJ','PA',DE')
The file can contain more state codes.
The output need to be passed on to a sequel in the where clause -
select * from taxcode
where state_code in ('NY','NJ','PA',DE')
So far I am successful only in adding a comma to all the 4 lines of records.
Please help.
10 More Discussions You Might Find Interesting
1. Email Antispam Techniques and Email Filtering
Hello all. I want some help procmail receipe. I tried to get some mails' sender and receiptient. Then tried to send them a bash script. But it didnot work. I try a lot of variation of the below receipe. Could anyone can help what is wrong on my receipe? Or if the recepie is correct what can be... (0 Replies)
Discussion started by: kedi
0 Replies
2. Solaris
Ladies/Gentlemen,
I am looking for a web-based tool to keep track of my Sun inventory. The following list of fields are fields I would like to store: Root Passwd (needs to be secure) / Hostid / Console Port / IP Address / Platform / Application / Hostname . . . you get the point.
Do any of... (4 Replies)
Discussion started by: pc9456
4 Replies
3. AIX
Hello there!
I have a RS-6000 7043-140 machine with AIX version 4.1.5, that is
working for almost 8 years now. It has a tty monitor. My problem
started when I upgraded my machine to install a gxt250 graphics adapter
card together with a 15" AOC VGA Monitor, logitech keyboard and mouse, ... (2 Replies)
Discussion started by: bright_genius
2 Replies
4. Shell Programming and Scripting
Fairly new scripter so please bare with me if what I have done below is not according to standards.
Okay...heres what I am trying to do. I have a pattern that I need to search for in a directory. This gives me a list of files that includes a control file that contains totals of the line nos for... (3 Replies)
Discussion started by: alfredo123
3 Replies
5. UNIX for Advanced & Expert Users
I gotta write a command to change the accounts in /etc/passwd that use a shell other than the bash to bash shell. those accounts that dont use a shell shouldnt get modified. assuming all the shell programs end in sh and other programs dont. and the result should go into /etc/passwd.rev
any hint? (4 Replies)
Discussion started by: metalwarrior
4 Replies
6. Shell Programming and Scripting
Hello Folks,
I would very much appreciate if I could get help/suggestions on a particular sed usage. I have to write a script to take version info from a version file, compute the image name, print error if the image does not exist.
The version file looks like below:
"
#
# version.cfg
#... (3 Replies)
Discussion started by: fatimap
3 Replies
7. Shell Programming and Scripting
Hi,
I'm very new to bash scripting and Linux in general. I'm running Ubuntu Server 10.04 and trying to write a bash script to launch a program. In doing so, I've come across a couple of things that I obviously don't understand. Here is a short script that exemplifies those things:
... (9 Replies)
Discussion started by: Carson Dyle
9 Replies
8. Forum Support Area for Unregistered Users & Account Problems
User name: Michael Mullig
<removed email addresses> (1 Reply)
Discussion started by: Mike Mullig
1 Replies
9. Shell Programming and Scripting
Hello ALL ,
i am requesting help on for this script i am preparing to get the result of a query in a excel sheet :
current Error:
Script : NO Excel file created.
requesting to know where i am going wrong.
#!/bin/ksh... (2 Replies)
Discussion started by: anirudhkashikar
2 Replies
10. IP Networking
Ggod evening.
I need your help please, in a Production system there is a process that download a xls file from an URL which is IMF(International Monetary Fund) and afterwards to be loaded into a databse table.
When testing conectivity from a unix server to IMF seems to work but when editing it... (9 Replies)
Discussion started by: alexcol
9 Replies
LEARN ABOUT DEBIAN
nwbpset
NWBPSET(1) nwbpset NWBPSET(1)
NAME
nwbpset - Create a bindery property or set its value
SYNOPSIS
nwbpset [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ]
DESCRIPTION
nwbpset Reads a property specification from the standard input and creates and sets the corresponding property. The format is determined by
the output of 'nwbpvalues -c'. nwbpset will hopefully become an important part of the bindery management suite of ncpfs, together with
'nwbpvalues -c'. See util/nwbpsecurity for an example.
As another example, look at the following command line:
nwbpvalues -t 1 -o supervisor -p user_defaults -c |
sed '2s/.*/ME/'|
sed '3s/.*/LOGIN_CONTROL/'|
nwbpset
With this command, the property user_defaults of the user object 'supervisor' is copied into the property login_control of the user object
'me'.
nwbpvalues -t 1 -o me -p login_control -c |
sed '9s/.*/ff/'|
nwbpset
This command disables the user object me.
Feel free to contribute other examples!
nwbpset looks up the file $HOME/.nwclient to find a file server, a user name and possibly a password. See nwclient(5) for more information.
Please note that the access permissions of $HOME/.nwclient MUST be 600 for security reasons.
OPTIONS
-h
-h is used to print out a short help text.
-S server
server is the name of the server you want to use.
-U user
user is the user name to use for login.
-P password
password is the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwbpset
prompts for a password.
-n
-n should be given if no password is required for the login.
-C
By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
this conversion by -C.
AUTHORS
nwbpset was written by Volker Lendecke. See the Changes file of ncpfs for other contributors.
nwbpset 8/7/1996 NWBPSET(1)