How can I remove dummy information from a file named results.txt with lines like this?Lines inside file are like this:_my0001_split00000000.txt:Total Dynamic Power    =   0.0000 mW        _my0001_split00000050.txt:Total Dynamic Power    = 117.5261 uW  (100%)And they should change to tab seperated format like this:0001    00000000    0.0000  mW  0001    00000050    117.5261    uW  
Split lines inside files with fixed width columns
text processing;columns;text formatting
How about a using sed instead of awk?sed -r 's/^_my([0-9]+)_split([0-9]+)\.txt:[^=]*=\s*([0-9.]+) *(\S+).*/\1\t\2\t\3 \4/' /path/to/file