[SOLVED] How to use AWK to trim file names

unixmon · 08-05-2015, 10:15 AM

I want to remove the .1.gz component of the following file names in a column listing using AWK

autoconf.1.gz
autoheader.1.gz
autom4te.1.gz
automake-1.11.1.gz
automake.1.gz
autopoint.1.gz

I have found a number of options using Google but they are either too complex or they don't apply to this at all. I know that there is a simple AWK statement that will do this, I am just having difficulty figuring it out.

pan64 · 08-05-2015, 10:16 AM

would be nice to see what have you really tried...

unixmon · 08-05-2015, 10:34 AM

First, I captured the names of the Linux man page 1-9 files and >> to a file that had 9 columns. Then I used the following command: awk '2>0{print $9}' ./LinuxCmds_v1e1.txt >> test to capture just the file, names which included the .1.gz component that I wish to remove. I think that AWK might be the right choice for this but I might have to use VI to do so. I can cheat by SCP'ing the file to my laptop, creating a word document and using Find/Replace or perhaps doing something like that in Excel, BUT I want to find a Linux solution. Any suggestions?

teckk · 08-05-2015, 12:27 PM

Not sure what you are trying to do. Here are some examples.

Code:

echo autoconf.1.gz | cut -d '.' -f1

echo autoconf.1.gz | awk -F '.' '{print $1}'

echo autoconf.1.gz | sed 's/.1.gz//'

Code:

#! /usr/bin/env bash

list="
autoconf.1.gz
autoheader.1.gz
autom4te.1.gz
automake-1.11.1.gz
automake.1.gz
autopoint.1.gz
"

#Example 1
for i in "$list"; do
  echo "$i" | cut -d '.' -f1
done

#Example 2
for i in $list; do
  echo ${i%%.*}
done

#Example 3
awk -F '.' '{print $1}' <<< "$list"

unixmon · 08-05-2015, 12:47 PM

Hi All,

Ended up using vi to do this. vi'd the file that contained

autoconf.1.gz
autoheader.1.gz
autom4te.1.gz
automake-1.11.1.gz
automake.1.gz
autopoint.1.gz

and did the following:

:s/.1.gz/ /

to get

autoconf
autoheader
autom4te
automake-1.11
automake
autopoint

Thanks for responding to my query. I am now an official member of linuxquestions.org!

Unixmon

unixmon · 08-05-2015, 12:49 PM

Correction

Actually :s/.1.gz/ /

needed the % to do all of the lines in the file

Unixmon

unixmon · 08-05-2015, 12:50 PM

Nuts!

Actually :s/.1.gz/ /

Unixmon

unixmon · 08-05-2015, 12:52 PM

:s/.1.gz/ /

grail · 08-05-2015, 12:53 PM

You may wish to have a look at sed and using your same solution

unixmon · 08-05-2015, 12:55 PM

Wow, I type a percent symbol after the colon in the vi edit string into this Quick Reply text box and, when the message posts, the percent symbol is gone. Could someone else give this a try to see if they get the same result?

unixmon · 08-05-2015, 12:59 PM

Can't figure out how to Mark as Solved :|

"Arghhh, it was me first day with the hook."

unixmon · 08-05-2015, 01:01 PM

There it was, right at the top... Doh!