Generate “item tag” pairs from “item,item,…|tag” lists [closed]

Question

The characteristics of the input data:

• Each line consists of two fields, separated by a pipe '|', where
• the first field is a comma-separated list of items, and
• the second field is a tag.

Input

100,210,354,462|acct
331,746,50|mis
90,263,47,14|sales

Output

100acct
210acct
354acct
462acct
331mis
746mis
50mis
90sales
263sales
47sales
14sales

Answer 1

Assuming the items contain no “|” and the tags contain no “,”:

awk -F '[,|]' '{for(i=1;i<NF;i++)print$i$NF}' input.txt

Answer 2

Will PERL do?

$ perl -ne 'chomp; @a=split(/\|/); @b=split(/,/,$a[0]); map{print "$_$a[1]\n"}@b' input.txt

Answer 3

Pure sed solution:

sed ':a;s/\(.*\),\([^,]*\)|\(.*\)/\2\3\n\1|\3/;ta;s/|//' input.file

Answer 4

And now, in bash and sed only:

cat test.txt| while IFS="|" read i t ; do echo $i | sed "s/\([0-9]\+\)/\1$t/g;s/,/\n/g" ; done

And in bash only (courtesy Nahuel Fouilleul):

 while IFS="|" read i t;do while read -d, j;do echo "$j$t";done <<<"$i,";done <test.txt

Answer 5

Sed...

sed -e 's/^\([0-9][0-9]*\),.*|\(.*\)/\1\2/'

if the first field isn't numeric, then it can be changed to something like

sed -e 's/^\([^,][^,]*\),.*|\(.*\)/\1\2/'