sed -> replace fixed text and parenthesis from string

Question

How to bring this expression

echo "ObjectId(5e257e424ed10b0015e3e780),'qwe',ObjectId(5e257e424ed10b0015e3e780),()"

to this

5e257e424ed10b0015e3e780,'qwe',5e257e424ed10b0015e3e780,()

using sed?

I use this:

echo "ObjectId(5e257e424ed10b0015e3e780),'qwe',ObjectId(5e257e424ed10b0015e3e780),()" | \
   sed 's/ObjectId(\([a-z0-9]\)/\1/'

You say expected is `5e257e424ed10b0015e3e780,'qwe',5e257e424ed10b0015e3e780,()`, but then you say "I cannot delete the final bracket". Please confirm what exact output you need. — Wiktor Stribiżew, Feb 07 '20 at 09:31
Have you tried using a regex tester like https://regex101.com/ to see if your regular expression is correct? — Bart, Feb 07 '20 at 09:33
@Bart regex101 should be used with caution when testing out patterns that should be POSIX BRE compliant, as the tool is only for PCRE, JS, Python `re` and Golang regex flavors. One should be aware how to "convert" the pattern later and what constructs to avoid. — Wiktor Stribiżew, Feb 07 '20 at 09:35
@WiktorStribiżew Good point! radya100 Please match your particular regex flavour when using a test tool — Bart, Feb 07 '20 at 09:36

score 7 · Accepted Answer · answered Feb 07 '20 at 09:27

7

You may use

sed 's/ObjectId(\([[:alnum:]]*\))/\1/g'

The POSIX BRE pattern means:

The \1 replacement will keep the Group 1 value only.

The g flag will replace all occurrences.

answered Feb 07 '20 at 09:27

Wiktor Stribiżew

Output is as expected, `5e257e424ed10b0015e3e780,'qwe',5e257e424ed10b0015e3e780,()`. Why does someone think this solution is wrong? – Wiktor Stribiżew Feb 07 '20 at 09:30
@radya100 Ok, I fixed the question formatting and removed the confusing part. – Wiktor Stribiżew Feb 07 '20 at 09:46
Perhaps `sed 's/ObjectId(\([^)]*\))/\1/g' file` ? – potong Feb 07 '20 at 12:50
@potong Sure, but in the question, the requirements for the part between parentheses are not specified. – Wiktor Stribiżew Feb 07 '20 at 12:51

1 Answers1