[SOLVED] Select first and last column using regex or linux command

Issue

I have [a text file][1] that looks something like this...

  ("oo" (set CANDRA-E-O 0) "ऊ") 
  ("o" (set CANDRA-E-O ?ऑ) "ओ")
  ("oa" "ऑ")
  ("au" "औ")

I need to extract the first and last columns like:

"oo", "ऊ"
"o", "ओ"
"oa", "ऑ"
"au", "औ"

I have managed to extract the first column. But not sure how to select the second column.

\ {2}\(\".+\"\ 

Solution

With your shown samples/attempts, please try following awk command. Written and tested in GNU awk.

awk -v FPAT='"[^"]*"' '{for(i=1;i<=NF;i++){printf("%s%s",$i,i==NF?ORS:OFS)}}' Input_file

Explanation: Simple explanation would be, setting FPAT to '"[^"]*"' which means setting field separator as regex form, from " to till next occurrence of " comes. Then in main program going through all fields of each line and printing them, when its last field of line then printing new line else printing spaces(to get all one line values into a single line).

Answered By - RavinderSingh13

Answer Checked By - Candace Johnson (WPSolving Volunteer)