Re: [gentoo-user] [OT] awk - sed - grep = tying-myself-up-in-knots

[Alexander Kapshuk]

On Wed, Feb 10, 2016 at 7:02 PM, Mick <michaelkintzios@×××××.com> wrote:
> I've been struggling to parse/split/substitute some names and numbers using a
> spreadsheet and think that this task may be easier to achieve using
> conventional *nix tools. The problem is I wouldn't know where to start.
>
> I have a directory with loads of images.  Each image file name has a
> description comprising hyphen-separated words and a part number, also hyphen
> separated; e.g.:
>
> some-description-with-words-012-63099.jpg
>
> The number and length of the words change for each file.  The part number
> always has two components separated by a hyphen, but may also change in length
> and acquire more/fewer digits.
>
> I need two outputs:
>
> 1. the description + " (per M²)", like so:
>
> some-description-with-words (per M²)
>
> 2. the part number, but replacing the hyphen with "/", like so:
>
> 012/63099
>
>
> I can list the directory contents and redirect all image file names into a txt
> file.  What I am looking for is some additional steps I can pipe it through to
> obtain the two outputs, either in the same file or different files.  These
> file(s) are then imported into a spreadsheet template and manipulated, before
> the result is ultimately exported from the spreadsheet and uploaded to a
> server as a CSV file.
>
> Is this parsing, splitting and substitution exercise achievable?  Any
> suggestions to try out?
>
> --
> Regards,
> Mick

To get the desired output in two distinct steps, you could try this:

echo 'some-description-with-words-012-63099.jpg' |
sed 's!-[0-9][0-9]*.*! (per M²)!'
some-description-with-words (per M²)

echo 'some-description-with-words-012-63099.jpg' |
sed 's![^0-9][^0-9]*!!; s![.][^0-9]*!!; s!-!/!'
012/63099

To get both types of output on the same line separated with white
space, you could try this:

echo 'some-description-with-words-012-63099.jpg' |
sed '
    H
    s!-[0-9][0-9]*.*! (per M²)!
    x
    s![^0-9][^0-9]*!!
    s![.][^0-9]*!!
    s!-!/!
    H
    g
    y!\n! !
'
some-description-with-words (per M²) 012/63099