Home > Net >  Parsing a column using shell scripting
Parsing a column using shell scripting

Time:01-04

I have a sqoop command in a shell script that returns a one column one row output like this:

enter image description here

Can you please help me with parsing this above output to get only the value 0? Thank you.

CodePudding user response:

According to your image:

…you're needing the forlast line, right?
Piping the the output to tail -n 2 should answer

| 0           |
---------------

and from there pipe then to head -n 1 and voila.

Another approche can be to remove dash lines with `grep -v -e '^--*$' to have

| Identifier  |
| 0           |

and from there, pipe then to tail -n 1 to retrieve the last line.

Finally, pipe to cut -d ' ' -f 2 or awk '{print $2}'

A refinement, if you want, will be to do the full stuff with sed or awk only. I may post an example if you want.

  • Related