StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to quickly find and replace many items on a list without replacing previously replaced items in BASH?
primarykey
Id
8019011
data
AcceptedAnswerId
8019297
AnswerCount
9
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2011-11-05T08:18:38.573
FavoriteCount
0
LastActivityDate
2013-07-15T23:14:22.027
LastEditDate
2013-07-09T02:30:47.590
LastEditorUserId
834616
OwnerUserId
834616
ParentId
0
PostTypeId
1
Score
1
ViewCount
509
LastEditorDisplayName
text
Body
I want to perform about many find and replace operations on some text. I have a UTF-8 CSV file containing what to find (in the first column) and what to replace it with (in the second column), arranged from longest to shortest. E.g.: <pre><code>orange,fruit2 carrot,vegetable1 apple,fruit3 pear,fruit4 ink,item1 table,item2 </code></pre> Original file: <pre><code>"I like to eat apples and carrots" </code></pre> Resulting output file: <pre><code>"I like to eat fruit3s and vegetable1s." </code></pre> However, I want to ensure that if one part of text has already been replaced, that it doesn't mess with text that was already replaced. In other words, I don't want it to appear like this (it matched "table" from within vegetable1): <pre><code>"I like to eat fruit3s and vegeitem21s." </code></pre> Currently, I am using this method which is quite slow, because I have to do the whole find and replace twice: (1) Convert the CSV to three files, e.g.: <pre><code>a.csv b.csv c.csv orange 0001 fruit2 carrot 0002 vegetable1 apple 0003 fruit3 pear 0004 fruit4 ink 0005 item1 table 0006 item 2 </code></pre> (2) Then, replace all items from <code>a.csv</code> in <code>file.txt</code> with the matching column in <code>b.csv</code>, using <code>ZZZ</code> around the words to make sure there is no mistake later in matching the numbers: <pre><code>a=1 b=`wc -l < ./a.csv` while [ $a -le $b ] do for i in `sed -n "$a"p ./b.csv`; do for j in `sed -n "$a"p ./a.csv`; do sed -i "s/$i/ZZZ$j\ZZZ/g" ./file.txt echo "Instances of '"$i"' replaced with '"ZZZ$j\ZZZ"' ("$a"/"$b")." a=`expr $a + 1` done done done </code></pre> (3) Then running this same script again, but to replace <code>ZZZ0001ZZZ</code> with <code>fruit2</code> from <code>c.csv</code>. Running the first replacement takes about 2 hours, but as I must run this code twice to avoid editing the already replaced items, it takes twice as long. Is there a more efficient way to run a find and replace that does not perform replacements on text already replaced?
Tags
<perl><bash><optimization><replace><sed>
Title
How to quickly find and replace many items on a list without replacing previously replaced items in BASH?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USVillage
UserOwnerUserId
1. USVillage
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow to quickly find and replace many items on a list without replacing previously replaced items in BASH?
 UserUserId
 USVillage
 VoteTypeVoteTypeId
 VTBountyStart
2. VO
 singulars
 PostPostId
 POHow to quickly find and replace many items on a list without replacing previously replaced items in BASH?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.