Ttgjyuk

Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?

Virginia employer terminated employee and wants signing bonus returned

Aliens englobed the Solar System: will we notice?

What are some noteworthy "mic-drop" moments in math?

They call me Inspector Morse

Regex for certain words causes Spaces

Why is Beresheet doing a only a one-way trip?

"One can do his homework in the library"

How do you like my writing?

Make a transparent 448*448 image

Time travel short story where dinosaur doesn't taste like chicken

Is it true that real estate prices mainly go up?

Word for a person who has no opinion about whether god exists

Is "history" a male-biased word ("his+story")?

Set and print content of environment variable in cmd.exe subshell?

Could you please stop shuffling the deck and play already?

infinitive telling the purpose

What does a stand alone "T" index value do?

Good for you! in Russian

Offered promotion but I'm leaving. Should I tell?

Should I take out a loan for a friend to invest on my behalf?

Who deserves to be first and second author? PhD student who collected data, research associate who wrote the paper or supervisor?

What wound would be of little consequence to a biped but terrible for a quadruped?

Best approach to update all entries in a list that is paginated?

RegEx - How to extract second matches using grep

How to make grep display only the matching regexp?Using Modifiers of Perl-compatible Regex (PCRE) in grepUsing grep with regexgrep single pattern having more than one matchesgrep regex pattern causes unexpected command behaviorScript to extract text using grepHow can I use the grep command to extract line which is the next line of greping line?How do I use grep to generateHow to grep two numbers from the same line at different places using bash?couldn't understand output of grep with regular expression while using pipe

0

How to extract second numbers in this text using grep command in ubuntu.

filename : Results.html?owner=12345

14219,98.2,31-s,19225
39219,92.7,31-s,29225

ouput desired :

12345:98.2
12345:92.7

Thanks

grep regex

share|improve this question

edited 45 mins ago

H.Otmane

asked 1 hour 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.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you really need a regex for this? something like cut -d, -f2 file would be simpler
  
  – steeldriver
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes im really need a regex in grep, because i have multiple files and by grep its a good for me because i get ouput with file name like this : file1:98.2
  
  – H.Otmane
  1 hour ago
  
  

  
  
  
  

add a comment | 

0

How to extract second numbers in this text using grep command in ubuntu.

filename : Results.html?owner=12345

14219,98.2,31-s,19225
39219,92.7,31-s,29225

ouput desired :

12345:98.2
12345:92.7

Thanks

grep regex

share|improve this question

edited 45 mins ago

H.Otmane

asked 1 hour 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.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you really need a regex for this? something like cut -d, -f2 file would be simpler
  
  – steeldriver
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes im really need a regex in grep, because i have multiple files and by grep its a good for me because i get ouput with file name like this : file1:98.2
  
  – H.Otmane
  1 hour ago
  
  

  
  
  
  

add a comment | 

How to extract second numbers in this text using grep command in ubuntu.

filename : Results.html?owner=12345

14219,98.2,31-s,19225
39219,92.7,31-s,29225

ouput desired :

12345:98.2
12345:92.7

Thanks

grep regex

share|improve this question

edited 45 mins ago

H.Otmane

asked 1 hour 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.

14219,98.2,31-s,19225
39219,92.7,31-s,29225

12345:98.2
12345:92.7

share|improve this question

edited 45 mins ago

H.Otmane

asked 1 hour 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.

share|improve this question

edited 45 mins ago

H.Otmane

asked 1 hour 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 1 hour 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 1 hour ago

H.OtmaneH.Otmane

52

2 Answers
2

active

oldest

votes

1

With GNU grep, you can switch to PCRE mode where you can use lookarounds to match a number surrounded by commas:

$ grep -HPo '(?<=,)[0-9.]*(?=,)' file
file:98.2
file:92.7

OTOH if your data are comma-delimited a better option might be Awk:

$ awk -F, 'print FILENAME ":" $2' file
file:98.2
file:92.7

or equivalently in perl perl -F, -nlE 'say "$ARGV:$F[1]"' file

---

To split the filename in Awk you can use

$ awk -F, 'split(FILENAME,a,/=/); print a[2] ":" $2' Results.html?owner=12345 
12345:98.2
12345:92.7

or (slightly more efficiently) if you have GNU Awk

gawk -F, 'BEGINFILEsplit(FILENAME,a,/=/) print a[2] ":" $2' Results.html?owner=12345

share|improve this answer

edited 36 mins ago

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks mr @steeldriver its working fine
  
  – H.Otmane
  55 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks awk its best, please my filename like this : Results.html?owner=12345 i want get ouput like this : 12345:98.2
  
  – H.Otmane
  50 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Edited :) thanks for your answer
  
  – H.Otmane
  44 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OMG i think isnt possible, but its possible with you mr steeldriver :) Thanks a lot
  
  – H.Otmane
  31 mins ago
  

  
  
  
  

add a comment | 

0

According to this thread, there is not a right way to achieve that using RegEx and grep.

In your case you can retrieve the desired second column of the input data you provided, using awk or sed. An example using awk is presented bellow:

#assuming test.dat contains your data
awk -F"," ' print $2 '

#assuming you want to read data from stdout
echo "14219,98.2,31-s,19225" | awk -F"," ' print $2 '

share|improve this answer

answered 45 mins ago

SarrimanSarriman

7317

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.

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1125160%2fregex-how-to-extract-second-matches-using-grep%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

With GNU grep, you can switch to PCRE mode where you can use lookarounds to match a number surrounded by commas:

$ grep -HPo '(?<=,)[0-9.]*(?=,)' file
file:98.2
file:92.7

OTOH if your data are comma-delimited a better option might be Awk:

$ awk -F, 'print FILENAME ":" $2' file
file:98.2
file:92.7

or equivalently in perl perl -F, -nlE 'say "$ARGV:$F[1]"' file

---

To split the filename in Awk you can use

$ awk -F, 'split(FILENAME,a,/=/); print a[2] ":" $2' Results.html?owner=12345 
12345:98.2
12345:92.7

or (slightly more efficiently) if you have GNU Awk

gawk -F, 'BEGINFILEsplit(FILENAME,a,/=/) print a[2] ":" $2' Results.html?owner=12345

share|improve this answer

edited 36 mins ago

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks mr @steeldriver its working fine
  
  – H.Otmane
  55 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks awk its best, please my filename like this : Results.html?owner=12345 i want get ouput like this : 12345:98.2
  
  – H.Otmane
  50 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Edited :) thanks for your answer
  
  – H.Otmane
  44 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OMG i think isnt possible, but its possible with you mr steeldriver :) Thanks a lot
  
  – H.Otmane
  31 mins ago
  

  
  
  
  

add a comment | 

1

With GNU grep, you can switch to PCRE mode where you can use lookarounds to match a number surrounded by commas:

$ grep -HPo '(?<=,)[0-9.]*(?=,)' file
file:98.2
file:92.7

OTOH if your data are comma-delimited a better option might be Awk:

$ awk -F, 'print FILENAME ":" $2' file
file:98.2
file:92.7

or equivalently in perl perl -F, -nlE 'say "$ARGV:$F[1]"' file

---

To split the filename in Awk you can use

$ awk -F, 'split(FILENAME,a,/=/); print a[2] ":" $2' Results.html?owner=12345 
12345:98.2
12345:92.7

or (slightly more efficiently) if you have GNU Awk

gawk -F, 'BEGINFILEsplit(FILENAME,a,/=/) print a[2] ":" $2' Results.html?owner=12345

share|improve this answer

edited 36 mins ago

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks mr @steeldriver its working fine
  
  – H.Otmane
  55 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks awk its best, please my filename like this : Results.html?owner=12345 i want get ouput like this : 12345:98.2
  
  – H.Otmane
  50 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Edited :) thanks for your answer
  
  – H.Otmane
  44 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OMG i think isnt possible, but its possible with you mr steeldriver :) Thanks a lot
  
  – H.Otmane
  31 mins ago
  

  
  
  
  

add a comment | 

With GNU grep, you can switch to PCRE mode where you can use lookarounds to match a number surrounded by commas:

$ grep -HPo '(?<=,)[0-9.]*(?=,)' file
file:98.2
file:92.7

OTOH if your data are comma-delimited a better option might be Awk:

$ awk -F, 'print FILENAME ":" $2' file
file:98.2
file:92.7

or equivalently in perl perl -F, -nlE 'say "$ARGV:$F[1]"' file

---

To split the filename in Awk you can use

$ awk -F, 'split(FILENAME,a,/=/); print a[2] ":" $2' Results.html?owner=12345 
12345:98.2
12345:92.7

or (slightly more efficiently) if you have GNU Awk

gawk -F, 'BEGINFILEsplit(FILENAME,a,/=/) print a[2] ":" $2' Results.html?owner=12345

share|improve this answer

edited 36 mins ago

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

$ grep -HPo '(?<=,)[0-9.]*(?=,)' file
file:98.2
file:92.7

$ awk -F, 'print FILENAME ":" $2' file
file:98.2
file:92.7

$ awk -F, 'split(FILENAME,a,/=/); print a[2] ":" $2' Results.html?owner=12345 
12345:98.2
12345:92.7

gawk -F, 'BEGINFILEsplit(FILENAME,a,/=/) print a[2] ":" $2' Results.html?owner=12345

share|improve this answer

edited 36 mins ago

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

answered 59 mins ago

steeldriversteeldriver

68.9k11113184

0

According to this thread, there is not a right way to achieve that using RegEx and grep.

In your case you can retrieve the desired second column of the input data you provided, using awk or sed. An example using awk is presented bellow:

#assuming test.dat contains your data
awk -F"," ' print $2 '

#assuming you want to read data from stdout
echo "14219,98.2,31-s,19225" | awk -F"," ' print $2 '

share|improve this answer

answered 45 mins ago

SarrimanSarriman

7317

add a comment | 

0

According to this thread, there is not a right way to achieve that using RegEx and grep.

In your case you can retrieve the desired second column of the input data you provided, using awk or sed. An example using awk is presented bellow:

#assuming test.dat contains your data
awk -F"," ' print $2 '

#assuming you want to read data from stdout
echo "14219,98.2,31-s,19225" | awk -F"," ' print $2 '

share|improve this answer

answered 45 mins ago

SarrimanSarriman

7317

add a comment | 

According to this thread, there is not a right way to achieve that using RegEx and grep.

In your case you can retrieve the desired second column of the input data you provided, using awk or sed. An example using awk is presented bellow:

#assuming test.dat contains your data
awk -F"," ' print $2 '

#assuming you want to read data from stdout
echo "14219,98.2,31-s,19225" | awk -F"," ' print $2 '

share|improve this answer

answered 45 mins ago

SarrimanSarriman

7317

#assuming test.dat contains your data
awk -F"," ' print $2 '

#assuming you want to read data from stdout
echo "14219,98.2,31-s,19225" | awk -F"," ' print $2 '

share|improve this answer

answered 45 mins ago

SarrimanSarriman

7317

answered 45 mins ago

SarrimanSarriman

7317

answered 45 mins ago

SarrimanSarriman

7317