extract a part of string from a file in shell scripting

Question

I have a file as below

<SHORTCUT COMMENTS ="" DBDNAME ="xsxx_db2" FOLDERNAME ="XS_SHARED" NAME ="Shortcut_to_xx_CNTC_T" OBJECTSUBTYPE ="Source Definition" OBJECTTYPE ="SOURCE" REFERENCEDDBD ="xsxx_db2" REFERENCETYPE ="LOCAL" REFOBJECTNAME ="XSC_CLNT_CNTC_T" REPOSITORYNAME ="xxxx" VERSIONNUMBER ="2"/>
<SHORTCUT COMMENTS ="" FOLDERNAME ="MK_SHARED" NAME ="Shortcut_to_CIF_FF_MOB_NBR" OBJECTSUBTYPE ="Target Definition" OBJECTTYPE ="TARGET" REFERENCETYPE ="LOCAL" REFOBJECTNAME ="CIFXx_NBR" REPOSITORYNAME ="eim_xx" VERSIONNUMBER ="1"/>
<SHORTCUT COMMENTS ="" DBDNAME ="FlatFile" FOLDERNAME ="XS" NAME ="Shortcut_to_xxFF_TX" OBJECTSUBTYPE ="Source Definition" OBJECTTYPE ="SOURCE" REFERENCEDDBD ="FlatFile" REFERENCETYPE ="LOCAL" REFOBJECTNAME ="DXX_FF_TX" REPOSITORYNAME ="xxxx" VERSIONNUMBER ="1"/>

I need to extract the values in "" that follows the string FOLDERNAME =

Output needed is

XS_SHARED 
MK_SHARED
XS

anubhava · Accepted Answer · 2014-04-03 19:54:11Z

1

You can use awk:

awk -F '^.*FOLDERNAME *= *"|"' '{print $2}' file
XS_SHARED
MK_SHARED
XS

It is usually better to use DOM parsers for XML rather than using awk/sed/grep though.

answered Apr 3, 2014 at 19:54

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

Comments

clt60 · Accepted Answer · 2014-04-03 19:54:30Z

1

With sed:

sed 's/.*FOLDERNAME *= *"\([^"]*\)".*/\1/' file

answered Apr 3, 2014 at 19:54

clt60

64.3k17 gold badges114 silver badges206 bronze badges

Comments

glenn jackman · Accepted Answer · 2014-04-03 20:19:47Z

1

grep -oP '(?<=FOLDERNAME =").+?(?=")' file

answered Apr 3, 2014 at 20:19

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

Comments

Sina · Accepted Answer · 2014-04-03 20:47:32Z

1

Actually you can do it with awk using file separator option:

awk 'BEGIN { FS = "FOLDERNAME =" } ; { print $2 }' file | awk -F'"' '{print $2}'

answered Apr 3, 2014 at 20:47

Sina

15411 bronze badges

Collectives™ on Stack Overflow

extract a part of string from a file in shell scripting

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related