Now I have a file format like


I want my output file like:


Can anybody tell me what the linux command will be for doing this?

closed as unclear what you're asking by Sparhawk, Jeff Schaller May 29 at 20:23

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Welcome to U/L! I noticed that you cross-posted here. Unfortunately, cross-posting on multiple sites is discouraged, and will result in the question being closed. – Sparhawk May 29 at 2:26
  • The cross-post has since been deleted. – Jeff Schaller May 29 at 20:23
  • Wendy, can you use some words to explain the transformation you're expecting, just so that Answerers don't have to guess themselves? – Jeff Schaller May 29 at 20:23
awk 'BEGIN { FS=","; OFS="," } $2 == "CD1" { print $2, $1, $3 }' inputfile
  • The second column is not "1" exactly, I just use 1 to represent the data, the exact data is "CD127", I replace "1" to CD127 in the command you gave but did not work – Wendy Huang May 28 at 20:31
  • And my input file actually not tab separate it's separate by "," and I updated the file format at this answer. – Wendy Huang May 28 at 20:59
  • 1
    @WendyHuang With the field separator changed and quotes, try awk -F, 'BEGIN{OFS=","} $2 == "CD1" { print $2, $1, $3 }' inputfile. I'm an awk noob, but it seems to do the job. – Freddy May 28 at 21:38
  • @Freddy I tried your command, it did extract the row that second column is "CD1" but it didn't print out the third column in the result. – Wendy Huang May 29 at 0:43
  • @WendyHuang Hmm, I can't reproduce it. Any difference if you use awk 'BEGIN{FS=","; OFS=","} $2 == "CD1" { print $2, $1, $3 }' inputfile? This is the same command, just different syntax. And if you remove $2 == "CD1" it should just swap column one and two of your data. If that doesn't help we'll have to wait for an expert... – Freddy May 29 at 1:13

Not the answer you're looking for? Browse other questions tagged or ask your own question.