Ttykuu

Is there a way to make member function NOT callable from constructor?

Why was the "bread communication" in the arena of Catching Fire left out in the movie?

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

Does the average primeness of natural numbers tend to zero?

LM317 - Calculate dissipation due to voltage drop

How to deal with fear of taking dependencies

Can I legally use front facing blue light in the UK?

Is Fable (1996) connected in any way to the Fable franchise from Lionhead Studios?

What are the advantages and disadvantages of running one shots compared to campaigns?

Is this homebrew feat, Beast of Burden, balanced?

Weird behaviour when using querySelector

Is it true that "The augmented fourth (A4) and the diminished fifth (d5) are the only aug and dim intervals that appear in diatonic scales"

Why is the design of haulage companies so “special”?

Shall I use personal or official e-mail account when registering to external websites for work purpose?

Calculate Levenshtein distance between two strings in Python

Prime joint compound before latex paint?

What is GPS' 19 year rollover and does it present a cybersecurity issue?

Is repealing the EU Withdrawal Act a precondition of revoking Article 50?

I see my dog run

How many letters suffice to construct words with no repetition?

Can a planet have a different gravitational pull depending on its location in orbit around its sun?

Are cabin dividers used to "hide" the flex of the airplane?

Why doesn't a const reference extend the life of a temporary object passed via a function?

What happens when a metallic dragon and a chromatic dragon mate?

extract characters between two commas?

Text processing - join every two lines with commasRemove entire row in a file if first column is repeatedMerging two files, one column at a timeJoin two textfiles on 1st column keeping order and unpairable lines from 1st fileHow to print lines if two fields have identical values?Delete lines that matches a string before commahow to remove comma and strings after a comma in a file?Fastest way to sum Nth column in text fileHow to extract the first row for each entry in the first column?Compare two files and get unmatched rows from the second file based on first and second column

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have a file with ~ 3 million rows, here is the first few lines of my file:

head out.txt
 NA
 NA
 NA
 NA
 NA
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752
 gene85752

For those rows that are separated by ",", I want to keep everything after the first comma and before the second comma.
This is my desired output:

outgood.txt
NA
NA
NA
NA
NA
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85752
gene85752

text-processing awk

share|improve this question

asked 2 hours ago

Anna1364Anna1364

439213

add a comment | 

1

I have a file with ~ 3 million rows, here is the first few lines of my file:

head out.txt
 NA
 NA
 NA
 NA
 NA
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752
 gene85752

For those rows that are separated by ",", I want to keep everything after the first comma and before the second comma.
This is my desired output:

outgood.txt
NA
NA
NA
NA
NA
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85752
gene85752

text-processing awk

share|improve this question

asked 2 hours ago

Anna1364Anna1364

439213

add a comment | 

I have a file with ~ 3 million rows, here is the first few lines of my file:

head out.txt
 NA
 NA
 NA
 NA
 NA
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752
 gene85752

For those rows that are separated by ",", I want to keep everything after the first comma and before the second comma.
This is my desired output:

outgood.txt
NA
NA
NA
NA
NA
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85752
gene85752

text-processing awk

share|improve this question

asked 2 hours ago

Anna1364Anna1364

439213

head out.txt
 NA
 NA
 NA
 NA
 NA
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753,gene85754
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752,gene85753
 gene85752
 gene85752

outgood.txt
NA
NA
NA
NA
NA
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85753
gene85752
gene85752

share|improve this question

asked 2 hours ago

Anna1364Anna1364

439213

share|improve this question

asked 2 hours ago

Anna1364Anna1364

439213

asked 2 hours ago

Anna1364Anna1364

439213

asked 2 hours ago

Anna1364Anna1364

439213

3 Answers
3

active

oldest

votes

6

Since cut prints non-delimited lines by default the following works

cut -f2 -d, file

share|improve this answer

answered 1 hour ago

iruvariruvar

12.3k63062

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It's nice when someone remember the little quirks of standard tools.
  
  – Kusalananda♦
  1 hour ago
  

  
  
  
  

add a comment | 

1

awk -F, 'NF > 1 $1 = $2 print $1 ' file

This uses awk to parse the file as lines consisting of comma-delimited fields.

The code detects when there is more than a single field on a line, and when there is, the first field is replaced by the second field. The first field, either unmodified or modified by the conditional code, is then printed.

share|improve this answer

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  With a big file, this would probably be faster: awk -F, 'print(NF>1 ? $2 : $1)' -- since you won't have to rewrite $0
  
  – glenn jackman
  13 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @glennjackman Well, the cut solution would be even faster in any case.
  
  – Kusalananda♦
  9 mins ago
  

  
  
  
  

add a comment | 

0

awk -F, 'NF == 1 print $1
 NF > 1 print $2' filename

This will print just the first string if there is no comma, second string if there is one or more comma.

share|improve this answer

answered 2 hours ago

unxnutunxnut

3,79721120

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');

var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);

;
$window.on('scroll', onScroll);

);

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%2funix.stackexchange.com%2fquestions%2f511284%2fextract-characters-between-two-commas%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

6

Since cut prints non-delimited lines by default the following works

cut -f2 -d, file

share|improve this answer

answered 1 hour ago

iruvariruvar

12.3k63062

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It's nice when someone remember the little quirks of standard tools.
  
  – Kusalananda♦
  1 hour ago
  

  
  
  
  

add a comment | 

6

Since cut prints non-delimited lines by default the following works

cut -f2 -d, file

share|improve this answer

answered 1 hour ago

iruvariruvar

12.3k63062

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It's nice when someone remember the little quirks of standard tools.
  
  – Kusalananda♦
  1 hour ago
  

  
  
  
  

add a comment | 

Since cut prints non-delimited lines by default the following works

cut -f2 -d, file

share|improve this answer

answered 1 hour ago

iruvariruvar

12.3k63062

cut -f2 -d, file

share|improve this answer

answered 1 hour ago

iruvariruvar

12.3k63062

answered 1 hour ago

iruvariruvar

12.3k63062

answered 1 hour ago

iruvariruvar

12.3k63062

1

awk -F, 'NF > 1 $1 = $2 print $1 ' file

This uses awk to parse the file as lines consisting of comma-delimited fields.

The code detects when there is more than a single field on a line, and when there is, the first field is replaced by the second field. The first field, either unmodified or modified by the conditional code, is then printed.

share|improve this answer

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  With a big file, this would probably be faster: awk -F, 'print(NF>1 ? $2 : $1)' -- since you won't have to rewrite $0
  
  – glenn jackman
  13 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @glennjackman Well, the cut solution would be even faster in any case.
  
  – Kusalananda♦
  9 mins ago
  

  
  
  
  

add a comment | 

1

awk -F, 'NF > 1 $1 = $2 print $1 ' file

This uses awk to parse the file as lines consisting of comma-delimited fields.

The code detects when there is more than a single field on a line, and when there is, the first field is replaced by the second field. The first field, either unmodified or modified by the conditional code, is then printed.

share|improve this answer

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  With a big file, this would probably be faster: awk -F, 'print(NF>1 ? $2 : $1)' -- since you won't have to rewrite $0
  
  – glenn jackman
  13 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @glennjackman Well, the cut solution would be even faster in any case.
  
  – Kusalananda♦
  9 mins ago
  

  
  
  
  

add a comment | 

awk -F, 'NF > 1 $1 = $2 print $1 ' file

This uses awk to parse the file as lines consisting of comma-delimited fields.

The code detects when there is more than a single field on a line, and when there is, the first field is replaced by the second field. The first field, either unmodified or modified by the conditional code, is then printed.

share|improve this answer

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

awk -F, 'NF > 1 $1 = $2 print $1 ' file

share|improve this answer

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

answered 2 hours ago

Kusalananda♦Kusalananda

140k17261435

0

awk -F, 'NF == 1 print $1
 NF > 1 print $2' filename

This will print just the first string if there is no comma, second string if there is one or more comma.

share|improve this answer

answered 2 hours ago

unxnutunxnut

3,79721120

add a comment | 

0

awk -F, 'NF == 1 print $1
 NF > 1 print $2' filename

This will print just the first string if there is no comma, second string if there is one or more comma.

share|improve this answer

answered 2 hours ago

unxnutunxnut

3,79721120

add a comment | 

awk -F, 'NF == 1 print $1
 NF > 1 print $2' filename

This will print just the first string if there is no comma, second string if there is one or more comma.

share|improve this answer

answered 2 hours ago

unxnutunxnut

3,79721120

awk -F, 'NF == 1 print $1
 NF > 1 print $2' filename

share|improve this answer

answered 2 hours ago

unxnutunxnut

3,79721120

answered 2 hours ago

unxnutunxnut

3,79721120

answered 2 hours ago

unxnutunxnut

3,79721120