AWK - How to extract matches including part of filename from multiple filesHow to print the line number when searching for a string in multiple filesCount the number of unique values based on two columns in a spreadsheetsed remove last 2 numeralsPrint a string a number of timesRemove duplicated dots from file nameremove 2nd line of output using awkExtract word from string using grep/sed/awkSearching line by line text between first two matchesawk - compare 2 files and print columns from both filesAWK split output with the line
Is Mortgage interest accrued after a December payment tax deductible?
How could a female member of a species produce eggs unto death?
Can the damage from a Talisman of Pure Good (or Ultimate Evil) be non-lethal?
Did CPM support custom hardware using device drivers?
What are the possible solutions of the given equation?
It's a yearly task, alright
Life insurance that covers only simultaneous/dual deaths
SQL Server Primary Login Restrictions
Identifying the interval from A♭ to D♯
Using "wallow" verb with object
Ban on all campaign finance?
Why did it take so long to abandon sail after steamships were demonstrated?
Be in awe of my brilliance!
How to deal with a cynical class?
How to deal with taxi scam when on vacation?
What is IP squat space
Why do Australian milk farmers need to protest supermarkets' milk price?
Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?
Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?
How to simplify this time periods definition interface?
An Accountant Seeks the Help of a Mathematician
Employee lack of ownership
Russian cases: A few examples, I'm really confused
Pinhole Camera with Instant Film
AWK - How to extract matches including part of filename from multiple files
How to print the line number when searching for a string in multiple filesCount the number of unique values based on two columns in a spreadsheetsed remove last 2 numeralsPrint a string a number of timesRemove duplicated dots from file nameremove 2nd line of output using awkExtract word from string using grep/sed/awkSearching line by line text between first two matchesawk - compare 2 files and print columns from both filesAWK split output with the line
i have 1000 files with filename like this :
total_val_count.html?itemid=5555
with content
total.val="number":1234,"Validation":YES
i want output like this itemid:number using awk
5555:1234
Thanks
grep sed awk
asked 3 hours ago
H.OtmaneH.Otmane
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
i have 1000 files with filename like this :
total_val_count.html?itemid=5555
with content
total.val="number":1234,"Validation":YES
i want output like this itemid:number using awk
5555:1234
Thanks
grep sed awk
asked 3 hours ago
H.OtmaneH.Otmane
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Are you sure that '?' sign is part of your filenames, since it is special tobashshell, or is it excerpt from apache log or something with calls to CGI bin executables?
– gmt42
2 hours ago
add a comment |
i have 1000 files with filename like this :
total_val_count.html?itemid=5555
with content
total.val="number":1234,"Validation":YES
i want output like this itemid:number using awk
5555:1234
Thanks
grep sed awk
asked 3 hours ago
H.OtmaneH.Otmane
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
i have 1000 files with filename like this :
total_val_count.html?itemid=5555
with content
total.val="number":1234,"Validation":YES
i want output like this itemid:number using awk
5555:1234
Thanks
grep sed awk
grep sed awk
asked 3 hours ago
H.OtmaneH.Otmane
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 hours ago
H.OtmaneH.Otmane
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 hours ago
H.OtmaneH.Otmane
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 hours ago
H.OtmaneH.Otmane
52
asked 3 hours ago
H.OtmaneH.Otmane
52
52
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
H.Otmane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Are you sure that '?' sign is part of your filenames, since it is special tobashshell, or is it excerpt from apache log or something with calls to CGI bin executables?
– gmt42
2 hours ago
add a comment |
Are you sure that '?' sign is part of your filenames, since it is special tobashshell, or is it excerpt from apache log or something with calls to CGI bin executables?
– gmt42
2 hours ago
Are you sure that '?' sign is part of your filenames, since it is special to
bash shell, or is it excerpt from apache log or something with calls to CGI bin executables?– gmt42
2 hours ago
Are you sure that '?' sign is part of your filenames, since it is special to
bash shell, or is it excerpt from apache log or something with calls to CGI bin executables?– gmt42
2 hours ago
add a comment |
1 Answer
1
active
oldest
votes
If you have GNU Awk:
$ gawk '
BEGINFILE
split(FILENAME,a,/=/)
match($0,/"number":[0-9]+/)
printf "%s:%dn", a[2], substr($0,9+RSTART,RLENGTH)
' total_val*
5555:1234
Or with Perl
$ perl -lnE '$x = (split /=/,$ARGV)[1]; say "$x:$1" if /"number":(d+)/' total_val*
5555:1234
In neither case is any checking done (for example, that the filename splits successfully on an = sign).
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
H.Otmane is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1125752%2fawk-how-to-extract-matches-including-part-of-filename-from-multiple-files%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you have GNU Awk:
$ gawk '
BEGINFILE
split(FILENAME,a,/=/)
match($0,/"number":[0-9]+/)
printf "%s:%dn", a[2], substr($0,9+RSTART,RLENGTH)
' total_val*
5555:1234
Or with Perl
$ perl -lnE '$x = (split /=/,$ARGV)[1]; say "$x:$1" if /"number":(d+)/' total_val*
5555:1234
In neither case is any checking done (for example, that the filename splits successfully on an = sign).
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
add a comment |
If you have GNU Awk:
$ gawk '
BEGINFILE
split(FILENAME,a,/=/)
match($0,/"number":[0-9]+/)
printf "%s:%dn", a[2], substr($0,9+RSTART,RLENGTH)
' total_val*
5555:1234
Or with Perl
$ perl -lnE '$x = (split /=/,$ARGV)[1]; say "$x:$1" if /"number":(d+)/' total_val*
5555:1234
In neither case is any checking done (for example, that the filename splits successfully on an = sign).
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
add a comment |
If you have GNU Awk:
$ gawk '
BEGINFILE
split(FILENAME,a,/=/)
match($0,/"number":[0-9]+/)
printf "%s:%dn", a[2], substr($0,9+RSTART,RLENGTH)
' total_val*
5555:1234
Or with Perl
$ perl -lnE '$x = (split /=/,$ARGV)[1]; say "$x:$1" if /"number":(d+)/' total_val*
5555:1234
In neither case is any checking done (for example, that the filename splits successfully on an = sign).
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
If you have GNU Awk:
$ gawk '
BEGINFILE
split(FILENAME,a,/=/)
match($0,/"number":[0-9]+/)
printf "%s:%dn", a[2], substr($0,9+RSTART,RLENGTH)
' total_val*
5555:1234
Or with Perl
$ perl -lnE '$x = (split /=/,$ARGV)[1]; say "$x:$1" if /"number":(d+)/' total_val*
5555:1234
In neither case is any checking done (for example, that the filename splits successfully on an = sign).
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
answered 2 hours ago
steeldriversteeldriver
69.2k11114185
69.2k11114185
add a comment |
add a comment |
H.Otmane is a new contributor. Be nice, and check out our Code of Conduct.
H.Otmane is a new contributor. Be nice, and check out our Code of Conduct.
H.Otmane is a new contributor. Be nice, and check out our Code of Conduct.
H.Otmane is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1125752%2fawk-how-to-extract-matches-including-part-of-filename-from-multiple-files%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Are you sure that '?' sign is part of your filenames, since it is special to
bashshell, or is it excerpt from apache log or something with calls to CGI bin executables?– gmt42
2 hours ago