12-05-2011
search replace regex question
Hi,
I need to run a search and replace on a large database,
what I need to change is all instances of
#### (eg. 1764 or 1964)
to
(####) (eg. (1764) or (1964))
But there might be other numbers in there such as
(1764) and I do not need those changed to ((1764))
How can I accomplish this?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a file that contains the following contents:
14:05 apple
orange123
456mango
16:45 banana
I wanted to replace ONLY the "14:05 " and "16:45" with nothing and trying to use the following syntax
sed -e 's/*//g' -e 's/^: //g' my_file > new_temp
cat new_temp
apple
orange... (2 Replies)
Discussion started by: ghazi
2 Replies
2. Shell Programming and Scripting
Hi all,
I have one question that hopefully isn't too complicated for the more advanced users here. In one of the Solaris KSH scripts I'm working on, is it possible to script the following:
- If there "is" an empty blank line "at the end" of /tmp/text.txt, then remove only that one empty... (3 Replies)
Discussion started by: chatguy
3 Replies
3. Shell Programming and Scripting
Thanks for giving your time and effort to answer questions and helping newbies like me understand awk.
I have a huge file, millions of lines, so perl takes quite a bit of time, I'd like to convert these perl one liners to awk.
Basically I'd like all lines with ISA sandwiched between... (9 Replies)
Discussion started by: verge
9 Replies
4. Shell Programming and Scripting
Hi
Input:
-
--
---
----
aa-bb-cc
aa--bb--cc
aa---bb---cc
aa----bb----cc
Output:
.
-
-.
--
aa.bb.cc (7 Replies)
Discussion started by: chitech
7 Replies
5. Shell Programming and Scripting
Hi,
I'm trying to match the front and back of a sequence. It works when there is an exact match (obviously), but I need the regex to be more flexible. When we get strings of nucleotides sometimes their prefixes and suffixes aren't exact matches. Sometimes there will be an extra letter and... (2 Replies)
Discussion started by: jdilts
2 Replies
6. Shell Programming and Scripting
Hi all,
I am trying to modify an xml file and I wanted to search and replace using the sed command but here is my issue. I want to search and replace maximumHeapSize="512" and replace it with maximumHeapSize="768" but I have multiple files with different values so I can't search for... (2 Replies)
Discussion started by: reyes99
2 Replies
7. Shell Programming and Scripting
I have file which contains data in the following format all in a single line:
BDW_PUBLN_ID DECIMAL(18:0) NOT NULL PRIMARY INDEX ARGO_ACCT_DEP_PI ( OFC_ID ,CSHBX_ID ,TRXN_SEQ_NUM ,PROCG_DT ) PARTITION BY RANGE_N(PROCG_DT BETWEEN DATE '2012-03-01' AND DATE '2014-12-31' EACH INTERVAL '1' MONTH );... (4 Replies)
Discussion started by: ysvsr1
4 Replies
8. Shell Programming and Scripting
I have text file like below:
a.txt
Server=abc
Run=1
Time=120.123
Tables=10
Sessions=16
Time=380.123
Version=1.1
Jobs=5
Server=abc
Run=2
Time=160.123
Tables=15
Sessions=16
Time=400.258
Version=2.0 (1 Reply)
Discussion started by: sol_nov
1 Replies
9. Shell Programming and Scripting
Have Pipe Delimited File:
> BRYAN BAKER|4/4/2015|518 VIRGINIA AVE|TEST
> JOE BAXTER|3/30/2015|2233 MockingBird RD|ROW2On 3rd column where the address is located, I want to add a space after every numeric value - basically doing a "s//&\ / ":
> BRYAN BAKER|4/4/2015|5 1 8 VIRGINIA AVE|TEST
> JOE... (5 Replies)
Discussion started by: svn
5 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Below is an excerpt from a 20000+ lines and I want to do a search and replace of a specific string but I don't know how and I can't figure out how to. Can't find an example from Google or anywhere to do what I am wanting to do.
A 2018-11-21 08:42:17 TEST_TEST 2018-11-21... (9 Replies)
Discussion started by: newbie_01
9 Replies
DBD(1) Netatalk 2.2 DBD(1)
NAME
dbd - CNID database maintenance
SYNOPSIS
dbd [-evx] {-d [-i] | -s [-c|-n] | -r [-c|-f] | -u} volumepath
DESCRIPTION
dbd can dump, scan, reindex and rebuild Netatalk dbd CNID databases. It must be run with appropiate permissions i.e. as root. dbd -s|-r
can be run on active volumes, but dbd -rf, which wipes the db before rebuilding it, checks and enforces that the chosen volume is not in
use.
COMMANDS
-d
Dump CNID database. With -i dump indexes too.
-s
Scan volume:
o Compare CNIDs in database with volume
o Test if .AppleDouble directories exist
o Test if AppleDouble files exist
o Report orphaned AppleDouble files
o Report directories inside .AppleDouble directories
o Check name encoding by roundtripping, log on error
o Check for orphaned CNIDs in database (requires -e)
o Open and close adouble files
Options:
-c Don't check .AppleDouble stuff, only check orphaned. -n Don't open CNID database, skip CNID checks, only traverse
filesystem
-r
Rebuild volume. With -f wipe database and rebuild from CNIIDs stored in AppleDouble files.
o Sync CNIDSs from database with volume
o Ensure .AppleDouble directories exist
o Ensure AppleDouble files exist
o Delete orphaned AppleDouble files
o Report directories inside .AppleDouble directories
o Check name encoding by roundtripping, log on error
o Delete orphaned CNIDs in database (requires -e)
o Open and close adouble files
Options:
-c Don't create .AppleDouble stuff, only cleanup orphaned.
-f Wipe database and rebuild from IDs stored in AppleDouble files, only available for volumes without nocnidcache option.
Implies -e.
-u
Upgrade:
Opens the database which triggers any necessary upgrades, then closes and exits.
OPTIONS
-e
Only work on inactive volumes and lock them (exclusive)
-x
Rebuild indexes (just for completeness, mostly useless!)
-v
verbose
WARNING
In order to be able to run -rf reconstructing the CNIDs in the database from the AppleDouble files, make sure you've run a -r rebuild
sometimes before, where the CNIDs then would have been synched between database and AppleDouble files.
Also be careful about the option nocnidcache. Avoid this option if at all possible, because if prevents you from being able to use -f.
CNID BACKGROUND
The CNID backends maintains name to ID mappings. If you change a filename outside afpd(8) (shell, samba), the CNID db will not know and not
reflect that change. Netatalk tries to recover from such inconsistencies as gracefully as possible. The mechanisms to resolve such
inconsistencies may fail sometimes, though, as this is not an easy task to accomplish. E.g. if several names in the path to the file or
directory have changed, things may go wrong.
If you change a lot of filenames at once, chances are higher that the afpds fallback mechanisms fail, i.e. files will be assigned new IDs,
even though the file hasn't changed.
SEE ALSO
cnid_metad(8), cnid_dbd(8)
Netatalk 2.2 12 Oct 2010 DBD(1)