Help with dynamic value string

Shell Programming and Scripting
1

Hi all,

Need help to seek string with dynamic value that always change?

Example string

JOB_WORK_STAFF_MARY_JANE_20111013_000000001.DAT

"JOB_WORK_STAFF_" and "_20111013_000000001.DAT" is static length.

How do I select the "MARY_JANE" in the middle of the string.
Please advice.

TQ.

2 
$ echo JOB_WORK_STAFF_MARY_JANE_20111013_000000001.DAT | awk 'BEGIN { FS="_"; OFS="_"; } { print $4, $5 }'
MARY_JANE
3
4

thanks for reply friends,

but i might be not explaining the situation very well.

all your script work well if the string is

JOB_WORK_STAFF_MARY_JANE_20111013_000000001.DAT

but when i mean dynamic value. The string could be as

JOB_WORK_STAFF_MARY_JANE_20111013_000000001.DAT
JOB_WORK_STAFF_MARY_JANE_LANE_20111013_000000001.DAT
JOB_WORK_STAFF_MARYJANELANE_20111013_000000001.DAT

expected output

MARY_JANE
MARY_JANE_LANE
MARYJANELANE
5 
$ sed 's,JOB_WORK_STAFF_,,g;s,_20111013_000000001.DAT,,g' infile
MARY_JANE
MARY_JANE_LANE
MARYJANELANE
$
1 Like
6

thanks so much jayan_jay.

your code work as expected.