Pavan Singh Pavan Singh - 4 months ago 11
Linux Question

How to eliminate everthing execpt required numbers while reading from .dat file?

I have

a .dat
file it contains data as:

count ------- 234 (1 row)


I want to retrieve the only 234 as integer and want to store in a variable in Shell script file.

I have used the below command:

WORKFLOW_STATUS_COUNT=`cat status_count.dat | tr -d " "`


but it is getting output as:

count ------- 234 (1 row)


but expected is 234 integer value.

Answer

You can use:

WORKFLOW_STATUS_COUNT=`cat status_count.dat | cut -d" " -f 3 `

cut splits the row with the spacebar delimeter and then choose only the third column

If the file come from Windows source you can try use dos2unix:

WORKFLOW_STATUS_COUNT=`cat status_count.dat | dos2unix | cut -d" " -f 3 `
Comments