Seqanswers Leaderboard Ad

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • Shishir
    Member
    • Nov 2012
    • 22

    Copy the column and paste it with special character

    Hi all,

    I have a input file like

    C3905550 oder CDS 68 646 . - . asmbl_487
    C3905550 oder exon 68 646 . - . asmbl_418
    C3918365 oder CDS 42 252 . + . asmbl_445
    C3918365 oder exon 42 252 . + . asmbl_443

    all columns are separed by TAB

    I want to create a new output file like :
    C3905550 oder CDS 68 646 . - . asmbl_487 "asmbl_487"
    C3905550 oder exon 68 646 . - . asmbl_418 "asmbl_418"
    C3918365 oder CDS 42 252 . + . asmbl_445 "asmbl_445"
    C3918365 oder exon 42 252 . + . asmbl_443 "asmbl_443"

    in the output file last column should be copied and pasted with "" and this new column should be separated by space not by TAB, and rest of column should be like in input file and separated by TAB

    Thanks!
  • rhinoceros
    Senior Member
    • Apr 2013
    • 372

    #2
    Stack Overflow | The World’s Largest Online Community for Developers


    It's the place to ask. Extremely fast feedback. Just make sure that your question hasn't been asked before..
    savetherhino.org

    Comment

    • sphil
      Senior Member
      • Apr 2010
      • 192

      #3
      awk '{ printf("%40s%40s%40s\n", $1, $2, '"$2"'); }' < input > output


      not tested but it should work

      else there is an entry on stackoverflow:

      Say I have file - a.csv ram,33,professional,doc shaym,23,salaried,eng Now I need this output (pls dont ask me why) ram,doc,doc, shayam,eng,eng, I am using cut command cut -d',' -f1,4,4 a.csv ...

      Comment

      Latest Articles

      Collapse

      • seqadmin
        Pathogen Surveillance with Advanced Genomic Tools
        by seqadmin




        The COVID-19 pandemic highlighted the need for proactive pathogen surveillance systems. As ongoing threats like avian influenza and newly emerging infections continue to pose risks, researchers are working to improve how quickly and accurately pathogens can be identified and tracked. In a recent SEQanswers webinar, two experts discussed how next-generation sequencing (NGS) and machine learning are shaping efforts to monitor viral variation and trace the origins of infectious...
        03-24-2025, 11:48 AM
      • seqadmin
        New Genomics Tools and Methods Shared at AGBT 2025
        by seqadmin


        This year’s Advances in Genome Biology and Technology (AGBT) General Meeting commemorated the 25th anniversary of the event at its original venue on Marco Island, Florida. While this year’s event didn’t include high-profile musical performances, the industry announcements and cutting-edge research still drew the attention of leading scientists.

        The Headliner
        The biggest announcement was Roche stepping back into the sequencing platform market. In the years since...
        03-03-2025, 01:39 PM

      ad_right_rmr

      Collapse

      News

      Collapse

      Topics Statistics Last Post
      Started by seqadmin, 03-20-2025, 05:03 AM
      0 responses
      42 views
      0 reactions
      Last Post seqadmin  
      Started by seqadmin, 03-19-2025, 07:27 AM
      0 responses
      51 views
      0 reactions
      Last Post seqadmin  
      Started by seqadmin, 03-18-2025, 12:50 PM
      0 responses
      38 views
      0 reactions
      Last Post seqadmin  
      Started by seqadmin, 03-03-2025, 01:15 PM
      0 responses
      194 views
      0 reactions
      Last Post seqadmin  
      Working...