padraig brady padraigbradycorvilcom declan grady wrote hi folks apologies wrong place ask trying linux desktop used os software im trying use combination bash scripts perl generate reports couple ascii files eventually run server get files ftp analyse mail results im programmer stretch imagination im getting bit lost deal single files eventually using grep egrep awk nice perl script called total found googling problem data im trying report split two isam files file 1 contains docket number line number item quantity price duedate file 2 contains docket number customer shipping date invoice number make sense data need relate docket number 2 files generate report customer first reaction look mysql import ascii data 2 tables use sql queries way go delve bit deeper perl advice welcome man join irish linux users group iluglinuxie httpwwwlinuxiemailmanlistinfoilug unsubscription information list maintainer listmasterlinuxie wed 21 aug 2002 123012 0100 ilug relating data 2 ascii files