Bash extract parts from string and create csv

Question

I have a document with 1+ million of the following strings and I like to create some new structures byextract some parts and create a csv file for it, what's the quickest way to do this?

document/0006-291X(85)91157-X

I would like to have a file with on each line the original string and the extracted parts

document/0006-291X(85)91157-X;0006-291X;85

What exactly do you want to extract? And what have you tried so far? — pfnuesel
– pfnuesel, Commented Nov 20, 2013 at 11:00

Bentoy13 · Accepted Answer · 2013-11-20 11:04:31Z

6

You can try this one-liner awk:

awk -F "[/()]" -v OFS=';' '{print $0,$(NF-2),$(NF-1)}' your-file

It parses the fields of each line with taking /,(,) as delimiters. Then it prints out the whole line, the 3rd field and the second field starting from the end of the line. The option -v OFS=';' prints semicolumns as output field separator.

answered Nov 20, 2013 at 11:04

Bentoy13

5,0061 gold badge23 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thomas Over a year ago

Thanks Bentoy13 that's very cool stuff which I didn't think off and works perfectly.

Collectives™ on Stack Overflow

Bash extract parts from string and create csv

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related