extract string from rows using awk based on string value

Question

I have a text file with data as:

(832555,488012,0,17:31:32.541,2014-08-06 17:31:32.000,0,0,NULL,FBCD,"-6484620512517810993"etcetcetc

I want to extract the string post FBCD so my output should be:

FBCD,"-6484620512517810993"etcetc

I am able to find the position of FBCD using awk:

awk '{print substr("FBCD",1,200)}' file.txt

but I cannot extract the remaining values.

Substr doesnt work like that

user3442743
– user3442743

2014-09-02 12:30:47 +00:00
Commented Sep 2, 2014 at 12:30 — user3442743
– user3442743, Commented Sep 2, 2014 at 12:30

score 3 · Accepted Answer · 2014-09-02 12:55:08Z

3

USing awk With substr

awk '{print substr($0,index($0,"FBCD"),200)' file

Using sed

sed -e 's/^.*\(FBCD.\{200\}\).*/\1/' file

If you want it till the end of the line

    awk '{print substr($0,index($0,"FBCD"))' file

    sed -e 's/^.*\(FBCD\)/\1/' file

edited Sep 2, 2014 at 12:55

answered Sep 2, 2014 at 12:35

user3442743

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

2 Comments

Ed Morton Over a year ago

+1 but I don't think the ,200 is useful. I think the OP was using that as just some large value to get the rest of the line because he didn't know that's what he'd get by just leaving that argument empty.

user3442743 Over a year ago

@EdMorton Edited in case that is what he wanted.

Kent · Accepted Answer · 2014-09-02 12:42:37Z

1

Your codes: substr("FBCD",1,200)

will cut the input string from char 1 - 200. but you gave FBCD as input string, and FBCD has only length 4, that's why you got only FBCD.

In fact, grep was born to extract things, would this help you?

grep -oE 'FBCD.{1,196}' file

edited Sep 2, 2014 at 12:42

answered Sep 2, 2014 at 12:18

Kent

197k36 gold badges248 silver badges317 bronze badges

6 Comments

iruvar Over a year ago

"grep was born to extract strings" - that may be debatable since the -o option to grep that you're using to extract is not in POSIX

user3442743 Over a year ago

@kent you have used a backtick instead of a quote

Kent Over a year ago

@Jidder oh, yes, I didn't test, was a typo, confused with markdown code block.... thanks.

Ed Morton Over a year ago

@1_CR is correct, grep was born to print the line containing a regexp (g/re/p). These days the GNU guys have their version of it recursively searching for files, cooking breakfast and all sorts of other things. I'm on the fence about whether -o was a good idea but at least it's not obviously a bad idea (unlike trying to do finds job).

Kent Over a year ago

@EdMorton so I should say grep was born to extract lines.. :)

|

Collectives™ on Stack Overflow

extract string from rows using awk based on string value

2 Answers 2

2 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related