|
|
Modify awk command to work in linux
11-23-2011
'1','3','COMMON','N','djpCM3PopDimDateGen','JobDescription','1','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim1','JobDescription','2','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim2','JobDescription','3','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim3','JobDescription','4','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim4','JobDescription','5','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim5','JobDescription','6','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim6','JobDescription','7','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim7','JobDescription','8','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDayRollingSum','JobDescription','9','ds','O','ONE' '1','3','COMMON','N','djpCM3PopWkRollingSum','JobDescription','10','ds','O','ONE' '1','3','COMMON','N','djpCM3LangIntLoad','JobDescription','11','ds','D','DIM' '1','3','COMMON','N','djpCM3GroupIntLoad','JobDescription','12','ds','D','DIM' '1','3','COMMON','N','djpCM3BankEntityGroupIntLoad','JobDescription','13','ds','D','DIM' '1','3','COMMON','N','djpCM3ChanlComnDimIntLoad','JobDescription','14','ds','D','DIM' '1','3','COMMON','N','djpCM3ChanlEvtAllDimsIntLoad','JobDescription','15','ds','D','DIM' '1','3','COMMON','N','djpCM3ChanlEvtStatIntLoad','JobDescription','16','ds','D','DIM' '1','3','COMMON','N','djpCM3CityIntLoad','JobDescription','17','ds','D','DIM' '1','3','COMMON','N','djpCM3CtryIntLoad','JobDescription','18','ds','D','DIM' '1','3','COMMON','N','djpCM3RegionIntLoad','JobDescription','19','ds','D','DIM' '1','3','COMMON','N','djpCM3TimeZoneIntLoad','JobDescription','20','ds','D','DIM' '1','3','COMMON','N','djpCM3DeviceIntLoad','JobDescription','21','ds','D','DIM' '1','3','COMMON','N','djpCM3PostalAddrLoad','JobDescription','22','ds','D','DIM' '1','3','COMMON','N','djpCM3PostalAddrDeviceLoad','JobDescription','23','ds','D','DIM' '1','3','COMMON','N','djpCM3EmplyIntLoad','JobDescription','24','ds','D','DIM' '1','3','COMMON','N','djpCM3CustIntLoad','JobDescription','25','ds','D','DIM' '1','3','ACCOUNTOPENING','N','djpCM3ApeLogDeleteStage','JobDescription','26','ds','D','DIM' '1','3','ACCOUNTOPENING','X','djpCM3PopDimAcctOwnType','JobDescription','27','ds','D','DIM'
`echo ${data2} | awk '{if (substr($1,0,1) == "\047") gsub("^\047+|\047+$", "", $0); gsub("\047,\047"," ",$0); print}'`1 3 COMMON N djpCM3PopDimDateGen JobDescription 1 ds O ONE' '1 3 COMMON N djpCM3PopDim1 JobDescription 2 ds O ONE' '1 3 COMMON N djpCM3PopDim2 JobDescription 3 ds O ONE' '1 3 COMMON N djpCM3PopDim3 JobDescription 4 ds O ONE' '1 3 COMMON N djpCM3PopDim4 JobDescription 5 ds O ONE' '1 3 COMMON N djpCM3PopDim5 JobDescription 6 ds O ONE' '1 3 COMMON N djpCM3PopDim6 JobDescription 7 ds O ONE' '1 3 COMMON N djpCM3PopDim7 JobDescription 8 ds O ONE' '1 3 COMMON N djpCM3PopDayRollingSum JobDescription 9 ds O ONE' '1 3 COMMON N djpCM3PopWkRollingSum JobDescription 10 ds O ONE' '1 3 COMMON N djpCM3LangIntLoad JobDescription 11 ds D DIM' '1 3 COMMON N djpCM3GroupIntLoad JobDescription 12 ds D DIM' '1 3 COMMON N djpCM3BankEntityGroupIntLoad JobDescription 13 ds D DIM' '1 3 COMMON N djpCM3ChanlComnDimIntLoad JobDescription 14 ds D DIM' '1 3 COMMON N djpCM3ChanlEvtAllDimsIntLoad JobDescription 15 ds D DIM' '1 3 COMMON N djpCM3ChanlEvtStatIntLoad JobDescription 16 ds D DIM' '1 3 COMMON N djpCM3CityIntLoad JobDescription 17 ds D DIM' '1 3 COMMON N djpCM3CtryIntLoad JobDescription 18 ds D DIM' '1 3 COMMON N djpCM3RegionIntLoad JobDescription 19 ds D DIM' '1 3 COMMON N djpCM3TimeZoneIntLoad JobDescription 20 ds D DIM' '1 3 COMMON N djpCM3DeviceIntLoad JobDescription 21 ds D DIM' '1 3 COMMON N djpCM3PostalAddrLoad JobDescription 22 ds D DIM' '1 3 COMMON N djpCM3PostalAddrDeviceLoad JobDescription 23 ds D DIM' '1 3 COMMON N djpCM3EmplyIntLoad JobDescription 24 ds D DIM' '1 3 COMMON N djpCM3CustIntLoad JobDescription 25 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3ApeLogDeleteStage JobDescription 26 ds D DIM' '1 3 ACCOUNTOPENING X djpCM3PopDimAcctOwnType JobDescription 27 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimAppReasonCde JobDescription 28 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimAppStat JobDescription 29 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimBusProc JobDescription 30 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimExchRate JobDescription 31 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimFnlSeq JobDescription 32 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimJrnyCde JobDescription 33 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimKPICde JobDescription 34 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimAdvt JobDescription 35 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimMedia JobDescription 36 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimCamp JobDescription 37 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimProd JobDescription 38 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimProd1 JobDescription 39 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimWebAddr JobDescription 40 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimPromo JobDescription 41 ds D DIM' '1 3 ACCOUNTOPENING N djpCM3PopDimProdPromoReln JobDescription 42 ds D DIM'
1 3 COMMON N djpCM3PopDimDateGen JobDescription 1 ds O ONE 1 3 COMMON N djpCM3PopDim1 JobDescription 2 ds O ONE 1 3 COMMON N djpCM3PopDim2 JobDescription 3 ds O ONE 1 3 COMMON N djpCM3PopDim3 JobDescription 4 ds O ONE
| Moderator's Comments: | ||
|
11-23-2011
$ cat junk '1','3','soho garden','tribeca','9','uptown storage'
$ cat junk | tr -d \' | awk 'BEGIN { FS=","; } { print $3; }'
soho garden| Moderator's Comments: | ||
|
11-24-2011
echo ${data2} | tr -d "'" | tr "," " "`echo ${data2} | tr -d "'" | tr "," " "`export IFS
| Moderator's Comments: | ||
|
|
|