Script Output

Input format :

A,Plan name ,L,M,B,Service Name,Pricing Rule,From Unit,To Unit, DISTI(USD) , MSRP(USD) , DIST(EUR) , MSRP(EUR) , EMEA-DISTI(USD) , EMEA-MSRP(USD) , GLOBAl-DISTI(USD) , GLOBAL-MSRP(USD) , DISTI(GBP) , MSRP(GBP) 
C1,P1,L1,M1,1,S1,Standard,1,,255,300,187.85,221,255,300,255,300,151.3,178
C2,P2,L2,M2,1,S2,Standard,1,2,1,2,3,4,5,6,7,8,9,10
C3,P2,L2,M2,1,S2,Standard,3,,11,12,13,14,15,16,17,18,19,20

Output Required :

<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>
XX,YY,P1,S1,  DISTI , USD ,0,1, ,255
XX,YY,P1,S1,  MSRP , USD ,1,1, ,300
XX,YY,P1,S1,  DIST , EUR ,0,1, ,187.85
XX,YY,P1,S1,  MSRP , EUR ,1,1, ,221
XX,YY,P1,S1,  EMEA-DISTI , USD ,0,1, ,255
XX,YY,P1,S1,  EMEA-MSRP , USD ,0,1, ,300
XX,YY,P1,S1,  GLOBAl-DISTI , USD ,0,1, ,255
XX,YY,P1,S1,  GLOBAL-MSRP , USD ,0,1, ,300
XX,YY,P1,S1,  DISTI , GBP ,0,1, ,151.3
XX,YY,P1,S1,  MSRP , GBP ,1,1, ,178
XX,YY,P2,S2,  DISTI , USD ,0,1,2,1
XX,YY,P2,S2,  MSRP , USD ,1,1,2,2
XX,YY,P2,S2,  DIST , EUR ,0,1,2,3
XX,YY,P2,S2,  MSRP , EUR ,1,1,2,4
XX,YY,P2,S2,  EMEA-DISTI , USD ,0,1,2,5
XX,YY,P2,S2,  EMEA-MSRP , USD ,0,1,2,6
XX,YY,P2,S2,  GLOBAl-DISTI , USD ,0,1,2,7
XX,YY,P2,S2,  GLOBAL-MSRP , USD ,0,1,2,8
XX,YY,P2,S2,  DISTI , GBP ,0,1,2,9
XX,YY,P2,S2,  MSRP , GBP ,1,1,2,10
XX,YY,P2,S2,  DISTI , USD ,0,3,,11
XX,YY,P2,S2,  MSRP , USD ,1,3,,12
XX,YY,P2,S2,  DIST , EUR ,0,3,,13
XX,YY,P2,S2,  MSRP , EUR ,1,3,,14
XX,YY,P2,S2,  EMEA-DISTI , USD ,0,3,,15
XX,YY,P2,S2,  EMEA-MSRP , USD ,0,3,,16
XX,YY,P2,S2,  GLOBAl-DISTI , USD ,0,3,,17
XX,YY,P2,S2,  GLOBAL-MSRP , USD ,0,3,,18
XX,YY,P2,S2,  DISTI , GBP ,0,3,,19
XX,YY,P2,S2,  MSRP , GBP ,1,3,,20

With jus one extra logic where the RATE SCHEDULE NAME is MSRP the IS_DEFAULT column should have value 1 else 0

Hi, what have you tried so far?

Scrutinizer here is two see

Sample output | Unix Linux Forums | Shell Programming and Scripting

Urgent ! | Unix Linux Forums | Shell Programming and Scripting

For the below input

CUSTOMER_ITEM_NUMBER,Plan,L1 Supp Plan,Master Plan,Billing Interval,Service Name,Pricing Rule,From Tier,To Tier, DISTI(USD) , MSRP(USD) , DIST(EUR) , MSRP(EUR) , EMEA-DISTI(USD) , EMEA-MSRP(USD) , GLOBAl-DISTI(USD) , GLOBAL-MSRP(USD) , DISTI(GBP) , MSRP(GBP) 
HSD-B1ACP-01PT1-A1S,HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic,HS DC B1A Master Plan - Academic,1,HS DC Compute Service,Volume Discount,1,1,5527.55,6503,4068.95,4787,5527.55,6503,5527.55,6503,3275.9,3854
HSD-B1ACP-01PT2-A1S,HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic,HS DC B1A Master Plan - Academic,1,HS DC Compute Service,Volume Discount,2,3,5348.2,6292,3937.2,4632,5348.2,6292,5348.2,6292,3170.5,3730
HSD-B1ACP-01PT3-A1S,HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic,HS DC B1A Master Plan - Academic,1,HS DC Compute Service,Volume Discount,4,5,5155.25,6065,3795.25,4465,5155.25,6065,5155.25,6065,3055.75,3595

-bash-3.2$ awk 'NR==1{for(i=10;i<=NF;i++){gsub(/\(|\)/,OFS,$i);A=$i}}NR>1{s=$1 OFS $2 OFS $3 OFS $4;for(i=10;i<=NF;i++)print $2,$3,A,$i}' FS=',' OFS=',' sample_1.txt

i'm getting the below output

HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DISTI,USD, ,5527.55
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,USD, ,6503
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DIST,EUR, ,4068.95
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,EUR, ,4787
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, EMEA-DISTI,USD, ,5527.55
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, EMEA-MSRP,USD, ,6503
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, GLOBAl-DISTI,USD, ,5527.55
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, GLOBAL-MSRP,USD, ,6503
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DISTI,GBP, ,3275.9
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,GBP, ,3854
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DISTI,USD, ,5348.2
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,USD, ,6292
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DIST,EUR, ,3937.2
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,EUR, ,4632
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, EMEA-DISTI,USD, ,5348.2
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, EMEA-MSRP,USD, ,6292
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, GLOBAl-DISTI,USD, ,5348.2
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, GLOBAL-MSRP,USD, ,6292
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DISTI,GBP, ,3170.5
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,GBP, ,3730
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DISTI,USD, ,5155.25
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,USD, ,6065
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DIST,EUR, ,3795.25
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,EUR, ,4465
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, EMEA-DISTI,USD, ,5155.25
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, EMEA-MSRP,USD, ,6065
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, GLOBAl-DISTI,USD, ,5155.25
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, GLOBAL-MSRP,USD, ,6065
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, DISTI,GBP, ,3055.75
HS DC B1A SP Compute 1 Month Prepaid - Academic,HS DC B1A SP GA Launch - Academic, MSRP,GBP, ,3595

I want 1 where A [i]has MSRP and 0 else

---------- Post updated at 04:57 AM ---------- Previous update was at 02:04 AM ----------

Hi Can anybody help on the above .. Thanks