Process `find` output parse out certain fields

Using sed

For convenience, let's put our find output into shell variable s:

$ s='/var/data/run/stores/user.rstd/info.settings:4: Password = "xxxxxxx";'

Now, let's extract the parts that you want:

$ echo "$s" | sed -E 's|/([^/]*/){4}([^/.]*)[.][^"]*(.*)|\2 \3|'
user "xxxxxxx";

How it works

The sed script consists of a single substitute command. The -E flag is used to enable extended regular expressions.

• The line is matched against: /([^/]*/){4}([^/.]*)[.][^"]*(.*)

  /([^/]*/){4} matches the first four directories. Because of the parens, the last of these directories is saved as group 1 but we will have no use for it.

  ([^/.]*) matches the user name without the extension. Because of the parens, this grouping is saved as group 2.

  [.][^"]* matches the extension and everything up to the first double-quote.

  (.*) matches everything starting with the first double-quote to the end of the line. Again, because of the parens, this is saved as group 3.

• The replacement text is \2 \3 which means group 2 followed by a space followed by group 3.

Using awk

$ echo "$s" | awk -v FS="/" '{ name=$6; sub(/[.].*/,"", name); sub(/[^"]*/, ""); print name, $0;}'
user "xxxxxxx";

How it works

• -v FS="/"

  This sets the field separator to /.

• name=$6; sub(/[.].*/,"", name)

  As awk counts fields, the name is in the sixth field. We save the sixth field in the variable name and then remove everything in name after the first period.

• sub(/[^"]*/, "")

  This removes everything from the line up to but not including the first ".

• print name, $0

  This prints the name, a field separator (default is a space), and what's is left of the line after the substitution (the password).

You can do that using sed grouping,

$ echo '/var/data/run/stores/user.rstd/info.settings:4: Password = "xxxxxxx";' | \
sed 's,\(^/var.*stores/\)\(user\)\(.rstd.*= \)\(.*\),\2  \4,'
user  "xxxxxxx";

I know it looks weird ;) alternatively you can use much simpler one

sed -e 's,/var/data/run/stores/,,;s,\..*=,,'

A long one... but seems working

$ echo '/var/data/run/stores/user.rstd/info.settings:4: Password = "xxxxxxx";'  | \
awk -F/ ' { print $6 $7} ' | awk -F"." ' { print $1, " ", $3 } ' | \
awk ' { print $1 " " $NF } '
user "xxxxxxx";