07-06-2018
Try using double quotes in lieu of single ones.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello All,
Plz help me with:
I have a csv file with data separated by ',' and optionally enclosed by "". I want to check each of these values to see if they exceed the specified string length, and if they do I want to cut just that value to the max length allowed and keep the csv format as it... (9 Replies)
Discussion started by: ozzy80
9 Replies
2. Shell Programming and Scripting
here is my sample file
dn: cn=Anandmohan Singh,ou=addressbook,dc=thbs,dc=com
objectClass: top
objectClass: person
objectClass: organizationalPerson
objectClass: inetOrgPerson
cn: Anandmohan Singh
givenName: Anandmohan
mail: anand_ms@thbs.com
mobile: 9986010455
ou: null... (16 Replies)
Discussion started by: namishtiwari
16 Replies
3. Shell Programming and Scripting
I want to create new file for 'NO 0004/01' and 'NO 0005/01' only
How can i do It for shot time
Data FILE Data.txt (Data ~1,000,000 Line)
START
NO 0001/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
TAIL AAA
END
START
B1
NO 0001/02
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
TAIL AAA (2 Replies)
Discussion started by: kittiwas
2 Replies
4. Shell Programming and Scripting
Mar 26 12:32:53 name sshd: 192.168.1.14
Mar 27 12:42:53 name sshd: 192.168.1.14
how to make this data in output as:
"Mar 26 12:32:53","name","sshd","192.168.1.14"
"Mar 27 12:42:53","name","sshd","192.168.1.14"
anyone plzz help me out!!!!!!!!!!!!!! (4 Replies)
Discussion started by: jacky29
4 Replies
5. Shell Programming and Scripting
perl -lne '$/="1H1XXXXX";print $_ if /0001|0002|0003/' data.txt> output.txt
more data.txt
1H1XXXXX|0001|Y|
aaa
bbb
ccc
1H1XXXXX|0005|N|
bbb
g
1H1XXXXX|0001|Y|
hhh
ddd
222
1H1XXXXX|0002|Y|
444
1H1XXXXX|0002|N|
222
1H1XXXXX|0003|Y|
hhhh (3 Replies)
Discussion started by: kittiwas
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I need some help with the cut command, can i use it to cut a certain number of characters from string starting from the end.
say my string is like this
some junk data xyz1@pqr.com xyz2@pqr.com some more junk data
I can't exactly say how many email addresses are present in between. But the... (4 Replies)
Discussion started by: poojabhat
4 Replies
7. Shell Programming and Scripting
HI Guys,
I have file A:
Abc XyZ Abc Xyz Kal Kaloo
Abc XyZ Abc Xyz Kalpooo
Abc XyZ Abc Xyz Kloo
Abc Abc Klooo
I want file B
Abc XyZ Abc Xyz Kal Kaloo
Abc XyZ Abc Xyz Kalpooo
Abc XyZ Abc Xyz Kloo
File A is now 1 lines
Abc Abc Klooo
Cut all lines which have xyz... (2 Replies)
Discussion started by: asavaliya
2 Replies
8. Shell Programming and Scripting
Hi in a directory i've files having the following name
for_category_info_19990101984301
for_catgry_meta_19991111214601
-------
I just want the name till year and month i.e;
for_category_info_199901
for_catgry_meta_199911
How can i achieve the above string
Thanks (2 Replies)
Discussion started by: smile689
2 Replies
9. Shell Programming and Scripting
---------- Post updated at 10:31 AM ---------- Previous update was at 10:28 AM ----------
Hello,
I am trying to get the string cut based on the following needs:
String1=Submitted request 25574824 for CONCURRENT SQLAP RUAPACTUALSEXT Y RUAPACTUALS122313100616.dat "2013/01/12 14:50:44"... (6 Replies)
Discussion started by: cartrider
6 Replies
10. What is on Your Mind?
Three days ago we received an expected notice from our long time data center that they were going dark on Sept 12th.
About one and a half hours ago, after three days of marathon work, I just cut over the unix.com to a new data center with a completely new OS and Ubuntu distribution. (22 Replies)
Discussion started by: Neo
22 Replies
LEARN ABOUT CENTOS
alter_user_mapping
ALTER USER
MAPPING(7) PostgreSQL 9.2.7 Documentation ALTER USER MAPPING(7)
NAME
ALTER_USER_MAPPING - change the definition of a user mapping
SYNOPSIS
ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
SERVER server_name
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
DESCRIPTION
ALTER USER MAPPING changes the definition of a user mapping.
The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
user_name
User name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future
user names in the system.
server_name
Server name of the user mapping.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the user mapping. The new options override any previously specified options. ADD, SET, and DROP specify the action
to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; options are also validated by
the server's foreign-data wrapper.
EXAMPLES
Change the password for user mapping bob, serverfoo:
ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');
COMPATIBILITY
ALTER USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). There is a subtle syntax issue: The standard omits the FOR key word. Since both
CREATE USER MAPPING and DROP USER MAPPING use FOR in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also
requires it for ALTER USER MAPPING, PostgreSQL diverges from the standard here in the interest of consistency and interoperability.
SEE ALSO
CREATE USER MAPPING (CREATE_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7))
PostgreSQL 9.2.7 2014-02-17 ALTER USER MAPPING(7)