awk-gsub on column-wise on each row

Shell Programming and Scripting
1

awk '{ gsub(/....=/,""); print }' want.dat >final.dat

the above awk command which removes all the chars before and including '=' on the entire row. --thats what it meant be.:slight_smile:

but i need to remove text on column-wise on each row.

many thanks,
EM

---------- Post updated at 10:00 AM ---------- Previous update was at 09:56 AM ----------

got a source data

ProductID=1	Name=Adjustable Race	ProductNumber=AR-5381	MakeFlag=0	FinishedGoodsFlag=0	Color=NULL	SafetyStockLevel=1000	ReorderPoint=750
ProductID=2	Name=Bearing Ball	ProductNumber=BA-8327	MakeFlag=0	FinishedGoodsFlag=0	Color=NULL	SafetyStockLevel=1000	ReorderPoint=750
ProductID=3	Name=BB Ball Bearing	ProductNumber=BE-2349	MakeFlag=1	FinishedGoodsFlag=0	Color=NULL	SafetyStockLevel=800	ReorderPoint=600

1	Adjustable Race	AR-5381	0	0	NULL	1000	750
2	Bearing Ball	BA-8327	0	0	NULL	1000	750
3	BB Ball Bearing	BE-2349	1	0	NULL	800	600

I need to remove the text before '=' including '=' till it hits the whitespace.

thanks for your help,
EM

2 
sed 's/[[:graph:]]*=//g' want.dat

awk '{for (i=1;i<=NF;i++) gsub(/.*=/,"",$i)}1' OFS="\t" want.dat
1 Like
3

i feel that's a tricky one with sed..kudos rdcwayx :b:

4

Thank you..its inspiring me to learn more..you guys ROCK!

6 
sed 's/[^=\t]*=//g' infile