09-02-2011
how to remove extra characters
Guys, I have a file that contains entries like this:
LaxOrdID=19220288<8>
LaxOrdID=19220288
I would like to remove <> and the values inside it anywhere its found.
How?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hopefully someone can help out here. This is probably fairly basic, but I've searched and tried several variations of the solutions presented in these forums, so I'll go ahead and ask.
How can I locate a string in a file, delete the characters after the string and then replace the string with a... (2 Replies)
Discussion started by: slaubhan
2 Replies
2. UNIX for Dummies Questions & Answers
Hi
my file data is like below
ramu,sony,"raju \n ravi \n ramya" \n
ravi,sarah,"sowmya \n sorry s\ sangam" \n
i want replace new line characters in between double coats with sinhle space.
for example
cat input_file
ramu,sony,"raju
ravi
ramya"
ravi,sarah,"sowmya
sorry
sangam"
... (3 Replies)
Discussion started by: Raghava
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
It's my first time here... anyways, I have a simple problem with these filenames. This is probably too easy for you guys:
ABC_20101.2A.2010_01
ABD_20103.2E.2010_04
ABE_20107.2R.2010_08
Expected Output:
ABC_20101
ABD_20103
ABE_20107
The only pattern available are the ff:
1) All... (9 Replies)
Discussion started by: Joule
9 Replies
4. Shell Programming and Scripting
I have data extracted like this:
A=%123% B=%456% C=%789%
A=%111% B=%222% C=%333%
A=%777% B=%888% C=%999%
Can someone please help me with a script to remove all the % signs and get the totals for A, B and C.
So output will be:
A=1368
B=666
C=2664
Thank you! (2 Replies)
Discussion started by: tatchel
2 Replies
5. Shell Programming and Scripting
Hi
I am using cat <filename> command in one of my datastage job(Command Activity). It is giving actual value but giving extra line.
Eg: Displayed Output: 1 and showing extraline(Eg: 1
) I had checked even wc -c it is giving one character extra.
If the file contains 11. wc -c says 3. ... (3 Replies)
Discussion started by: cnrj
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a .csv file which as empty lines with comma and some special characters in 3rd column as below.
Source data
1,2,3,4,%#,6
,,,,,,
1,2,3,4,5,6
Target Data
1,2,3,4,5,6I need to remove blank lines and special charcters
I am trying to get this using the below awk
awk -F","... (2 Replies)
Discussion started by: shruthidwh
2 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I have a text file that looks like:
ABC123|some text|some more text|00001
00002
0003
0004
000019|000003|Item
I have searched and found an example to remove the extra new line characters using grep and sed, but it (I think) assumes the lines start with a number and the... (5 Replies)
Discussion started by: c56444
5 Replies
8. Shell Programming and Scripting
Greetings..
getting the error while execution of the script, correct where i am missing
#!/bin/bash
DATE=`date +%Y-%m-%d:::%H:%M`
HOSTNAME=`hostname`
TXT="/log/temp.txt"
LOGPATH="/log1/commanlogs/"
IP=`/sbin/ifconfig | grep -i inet| head -n1| awk '{print $2}'| awk -F : '{print $2}'`... (7 Replies)
Discussion started by: manju98458
7 Replies
9. UNIX for Dummies Questions & Answers
Hi ,
I have file like this..
aaa|bbbb|cccc|dddd|fff|dsaaFFDFD|
Adsads|sas|sa|as|asa|saddas|dsasd|sdad|
dsas|dss|sss|sss|ddd|dssd|rrr|fddf|
www|fff|refd|dads|fsdf|00sd|
5fgdg|dfs00|d55f|sfds55|445fsd|55ds|sdf|
so I do no have any fix pattern and I want to remove extra... (11 Replies)
Discussion started by: pankajchaudhari
11 Replies
10. UNIX for Dummies Questions & Answers
The result of following command give me output which i further need to make some cosmetic change.
grep -E "ERROR.*Session" wf_Load_25.log | awk '{print $14}'
Output:
:
Expected Output:
s_Load_XMLFile_Into_HashCustLoan_25
Please help, i am using bash (2 Replies)
Discussion started by: Ariean
2 Replies
LEARN ABOUT CENTOS
drop_database
DROP
DATABASE(7) PostgreSQL 9.2.7 Documentation DROP DATABASE(7)
NAME
DROP_DATABASE - remove a database
SYNOPSIS
DROP DATABASE [ IF EXISTS ] name
DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only
be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to
postgres or any other database to issue this command.)
DROP DATABASE cannot be undone. Use it with care!
PARAMETERS
IF EXISTS
Do not throw an error if the database does not exist. A notice is issued in this case.
name
The name of the database to remove.
NOTES
DROP DATABASE cannot be executed inside a transaction block.
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb(1)
instead, which is a wrapper around this command.
COMPATIBILITY
There is no DROP DATABASE statement in the SQL standard.
SEE ALSO
CREATE DATABASE (CREATE_DATABASE(7))
PostgreSQL 9.2.7 2014-02-17 DROP DATABASE(7)