[SOLVED] awk and sed on one command

phpshell · 06-18-2013, 04:15 AM

is it possible to do the below output on one command

"73ARAR413:1-1-2-13","4-664-7777",\N,\N,"ADSL_Auto_256-128-ASAM","ADSL_Auto_256-128-ASAM",1,"ADSL","37.0","37.0","6.0","6.0",
"POTS"
"HUWV_SLMNRDFK_AULA096-A:1-0-1-5","11-462-8888","B5004244434D0000","B5004244434D0000"
VDSL2","30.0","30.0","6.0","6.0","POTS"

output should be
73ARAR413:1-1-2-13,46647777
HUWV_SLMNRDFK_AULA096-A:1-0-1-5,114628888

i did many try but need more one command to do that
more file | awk -F, '{print $1","$2}' | sed -e 's/"//g' > 1
73ARAR413:1-1-2-13,4-664-7777
HUWV_SLMNRDFK_AULA096-A:1-0-1-5,11-462-8888

druuna · 06-18-2013, 04:37 AM

Is your example spread over 4 lines or are there just 2?

Also: put your script/data inside [code] ... [/code] tags it preserves all spacing. If you don't know how: LQ - BB Code List.

pan64 · 06-18-2013, 04:51 AM

you do not need more, awk -F, '{print $1","$2}' filename should work.
also sed 's/"//g' can be executed in awk, gsub("\"", ""), so finally you will have:

Code:

awk -F, '{gsub("\"", ""); print $1","$2}' filename

druuna · 06-18-2013, 04:54 AM

@pan64: The dashes in field 2 also need removing, assuming there are just 2 lines I came up with this:

Code:

awk -F, '{ gsub(/\"/,"") ; gsub(/-/,"",$2) ; print $1","$2}' infile

But all goes out the window if there are actually 4 lines.....

phpshell · 06-18-2013, 04:56 AM

it just 2 lines

i am doing the below coding to get the output which very long

Code:

more file | awk -F, '{print $1","$2}' | sed -e 's/"//g' > 1

then

Code:

more 1 | awk -F, '{print $2}' | tr -d "-" > 2

last stage

Code:

paste 2 1 | sed -e 's/\t/,/g' | awk -F, '{print $2,$1}'

phpshell · 06-18-2013, 05:01 AM

Quote:

Originally Posted by druuna

@pan64: The dashes in field 2 also need removing, assuming there are just 2 lines I came up with this:

Code:

awk -F, '{ gsub(/\"/,"") ; gsub(/-/,"",$2) ; print $1","$2}' infile

But all goes out the window if there are actually 4 lines.....

many thanks for you man. this is what I am looking for

Quote:

1 members found this post helpful.

druuna · 06-18-2013, 05:29 AM

Glad to read this is fixed.

Do provide relevant examples the next time you ask a question.

Can you put up the [SOLVED] tag.
- above the first post -> Please Mark this thread as solved if you feel a solution has been provided.
- -or- -
- first post -> Thread Tools -> Mark this thread as solved

pan64 · 06-18-2013, 05:55 AM

Oh, yes, but sometimes I feel I should not solve it completely just give a hint or tip.

grail · 06-18-2013, 09:43 AM

Another alternative:

Code:

awk -F"\"(,\")?" '{print $2,gensub(/-/,"","g",$3)}' OFS="," file