Skip to main content
Super User

Return to Answer

Format code
Source Link
edit approved Apr 29, 2017 at 23:05
Stephen Rauch
edit approved Apr 29, 2017 at 23:05
Stephen Rauch
  • 3.2k
  • 10
  • 24
  • 26

I can not add commits. YourYour answer sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' > file2.:

sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' > file2

To get 'NA' in the last field if blank, sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'> file2.:

sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'> file2

You could also use sed 's/,,/,NA,/g' file1 | tr -d ' ' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'.:

sed 's/,,/,NA,/g' file1 | tr -d ' ' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'

I can not add commits. Your answer sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' > file2. To get 'NA' in the last field if blank, sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'> file2. You could also use sed 's/,,/,NA,/g' file1 | tr -d ' ' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'.

Your answer:

sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' > file2

To get 'NA' in the last field if blank:

sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'> file2

You could also use :

sed 's/,,/,NA,/g' file1 | tr -d ' ' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'
Source Link
bstipe
bstipe
  • 111
  • 3

I can not add commits. Your answer sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' > file2. To get 'NA' in the last field if blank, sed 's/ *,/,/g' file1 | sed 's/,,/,NA,/g' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'> file2. You could also use sed 's/,,/,NA,/g' file1 | tr -d ' ' | awk -F, 'OFS="," {if ($NF == "") $NF = "NA"; print}'.