Sorting stuff - awk? sort? other?

[Azrael2]

Hello! I have data I need to sort into a csv file to import into mysql. I can do it, but right now, it looks like making an awk script to make an awk script to make an wak script, which I hate. Perhaps one of you kind fellows could offer a more elegant solution?

[problem] I have 2 files. Each file is fairly similar format wise.
an example is
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8

So "customer" is our constant. What I would like is a CSV file that reads
CUSTOMER info1 info2 ... infoN
on each line.

Does this make sense? Any ideas?

[kakariko81280]

Once again, probably an inelegant solution, but it works.

chris@angua:~/dev/scratch$ cat test.txt
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info1 info2 CUSTOMER info3 info4
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
info5 CUSTOMER info6 info7 info8
chris@angua:~/dev/scratch$ sed -n -e 's/\(.* \)\(CUSTOMER \)\(.*\)/\2\1\3/' -e 's/ /,/gp' test.txt
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info1,info2,info3,info4
CUSTOMER,info5,info6,info7,info8
CUSTOMER,info5,info6,info7,info8
CUSTOMER,info5,info6,info7,info8
CUSTOMER,info5,info6,info7,info8
CUSTOMER,info5,info6,info7,info8
CUSTOMER,info5,info6,info7,info8

Let us know how you get on,

Chris...

[Azrael2]

crikey, I completely forgot about this for a while, but the way I solved it in the end was to load it into a MySQL database using awk to seperate them into different tables, and then re-joining them where necessary with SQL.

Thanks a lot though, that should come in very handy for the future. In fact, it may be just what I need for another problem I have...