UNIX for Dummies Questions & Answers

File: myfile.dat
File has content like this: ABCD, 34, 456, 2324
 
I would like excel to have this:
 
Name (ABCD) Quantity (34), Type (456), Status (2324)
 
(Name, Quantity, Type and Status are columns)

Name Quantity Type Status
ABCD 34          456  2324
XYX  24          21X T

( printf "Name,Quantity,Type,Status\r\n" ; sed 's/$/\r/g' ) < input > output.csv

$ cat file
Name (ABCD) Quantity (34), Type (456), Status (2324)

$ cat tester
awk  'FNR==1{
		gsub(/,/,OFS,head)
		print head
		gsub(OFS,"|",head);
		head = head "|,|[()]"
	    }
	    {
		gsub(head,x)
		$1 = $1
	    }1' head="Name,Quantity,Type,Status" OFS="\t" file

$ ./tester
Name	Quantity  Type	Status
ABCD	34	   456	 2324