Read from file into variable - Bash Script take2

Question

This is a second part of Read from file into variable - Bash Script

I have a bash script that reads strings in a file parses and assigns it to a variable. The file looks like this (file.txt):

database1 table1
database1 table4
database2
database3 table2

Using awk in the script:

s=$(awk '{$1=$1}1' OFS='.' ORS='|' file.txt)
LIST="${s%|}"

echo "$LIST"
database1.table1|database1.table4|database2|database3.table2

But I need to add some wildcards at the end of each substring. I need this result:

database1.table1.*|database1.table4.*|database2*.*|database3.table2.*

The conditions are: if we read database2 the output should be database2*.* and if we read a database and a table the output should be database1.table1.*

anubhava · Accepted Answer · 2014-05-01 18:51:31Z

0

Use this awk with ORS='.*|':

s=$(awk '$0=="database2"{$0=$0 "*.*";print;next} {$2=$2 ".*"}1' OFS='.' ORS='|' file.txt)
LIST="${s%|}"

echo "$LIST"
database1.table1.*|database1.table4.*|database2*.*|database3.table2.*

edited May 1, 2014 at 18:51

answered May 1, 2014 at 17:18

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

jaypal singh Over a year ago

This is quite close. But OP is looking for database2*.* instead of database2.*, though I have my doubts on his expected output.

anubhava Over a year ago

Yes I have same doubt because database2.* appears more correct regex

andresg3 Over a year ago

Thats correct. I'm looking for database2*.* instead of database2.*

anubhava Over a year ago

@andresg3: How are you going to use database2*.* Do you really want to match 0 or more occurrences of digit 2 using this regex?

Stephen P Over a year ago

Maybe it's a glob, not a regex.

|

Etan Reisner · Accepted Answer · 2014-05-02 01:13:14Z

0

Assuming the (slightly odd) regex is correct the following awk script works for me on your example input.

BEGIN {OFS="."; ORS="|"}
!$2 {$1=$1"*"}
{$(NF+1)="*"}
1

Set OFS and ORS.
If we do not have a second field add a * to our first field.
Add a * as a final field.
Print the line.

Run as awk -f script.awk inputfile where the above script is in the script.awk (or whatever) file.

edited May 2, 2014 at 1:13

answered May 1, 2014 at 18:27

Etan Reisner

81.7k8 gold badges120 silver badges154 bronze badges

1 Comment

Etan Reisner Over a year ago

@andresg3 That was just the awk script body itself. Sorry if that was unclear.

Vab · Accepted Answer · 2022-09-09 20:52:17Z

0

I'd do it like this.

script.sh containing the following code:

#!/bin/bash

while IFS='' read -r line ;do
  database=$(awk '{print $1}' <<< $line)
     table=$(awk '{print $2}' <<< $line)
  if [ "${table}" == '' ] ;then
    list=(${list}\|${database}\*\.\*)
  else
    list=(${list}\|${database}\.${table}\.\*)
  fi
done <file.txt

list=$(cut -c 2- <<< ${list})
echo ${list}

exit 0

file.txt containing the following data:

database1 table1
database1 table4
database2
database3 table2

Script output is the following:

database1.table1.*|database1.table4.*|database2*.*|database3.table2.*

Tested in BASH version: GNU bash, version 5.0.17(1)-release (x86_64-pc-linux-gnu)

answered Sep 9, 2022 at 20:52

Vab

4524 silver badges14 bronze badges

Collectives™ on Stack Overflow

Read from file into variable - Bash Script take2

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related