Hi gurus,
we have a input file where the first line has tags and subsequent lines have corresponding data.
I want to remove the tag and data for the below two operation from the input file and place in two different files
1)CREATE L2 SUPP PLAN
2)UPDATE PLAN ADD RATE SCHEDULE
HTML Code:
Input File
<OPERATION_NAME>,<service_name>,<service_type>,<gl_cd>,<Taxable>,<Tag Group>,<Usage Type>,,,
CREATE SERVICE,,,,,,,,,
CREATE SERVICE,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<plan_type>,<currency>,<billing_interval>,<active>,<rollover_months>,<pricing_rule>,<parent_plan>
CREATE MASTER PLAN,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>
CREATE MASTER PLAN,,,,,,,,,
CREATE MASTER PLAN,,,,,,,,,
CREATE MASTER PLAN,,,,,,,,,
CREATE MASTER PLAN,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<plan_type>,<currency>,<billing_interval>,<active>,<rollover_months>,<pricing_rule>,<parent_plan>
CREATE L1 SUPP PLAN,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>
CREATE L1 SUPP PLAN,,,,,,,,,
CREATE L1 SUPP PLAN,,,,,,,,,
CREATE L1 SUPP PLAN,,,,,,,,,
CREATE L1 SUPP PLAN,,,,,,,,,
<OPERATION_NAME>,<plan_name>,<plan_type>,<service_name>,<is_Default>,MSRP(USD),DISTI(USD),EMEA-MSRP(USD),EMEA-DISTI(USD),
CREATE L2 SUPP PLAN,,,,,,,,,
CREATE L2 SUPP PLAN,,,,,,,,,
<OPERATION_NAME>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<FROM_UNIT>,<TO_UNIT>,<AMOUNT>,<PRICING_RULE>
UPDATE PLAN ADD SERVICE,,,,,,,,,
UPDATE PLAN ADD SERVICE,,,,,,,,,
UPDATE PLAN ADD SERVICE,,,,,,,,,
UPDATE PLAN ADD SERVICE,,,,,,,,,
<OPERATION_NAME>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>,<pricing_rule>
UPDATE PLAN ADD RATE SCHEDULE,,,,,,,,,
UPDATE PLAN ADD RATE SCHEDULE,,,,,,,,,
HTML Code:
OUTPUT
FILE 1
======
<OPERATION_NAME>,<service_name>,<service_type>,<gl_cd>,<Taxable>,<Tag Group>,<Usage Type>,,,
CREATE SERVICE,,,,,,,,,
CREATE SERVICE,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<plan_type>,<currency>,<billing_interval>,<active>,<rollover_months>,<pricing_rule>,<parent_plan>
CREATE MASTER PLAN,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>
CREATE MASTER PLAN,,,,,,,,,
CREATE MASTER PLAN,,,,,,,,,
CREATE MASTER PLAN,,,,,,,,,
CREATE MASTER PLAN,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<plan_type>,<currency>,<billing_interval>,<active>,<rollover_months>,<pricing_rule>,<parent_plan>
CREATE L1 SUPP PLAN,,,,,,,,,
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>
CREATE L1 SUPP PLAN,,,,,,,,,
CREATE L1 SUPP PLAN,,,,,,,,,
CREATE L1 SUPP PLAN,,,,,,,,,
CREATE L1 SUPP PLAN,,,,,,,,,
<OPERATION_NAME>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<FROM_UNIT>,<TO_UNIT>,<AMOUNT>,<PRICING_RULE>
UPDATE PLAN ADD SERVICE,,,,,,,,,
UPDATE PLAN ADD SERVICE,,,,,,,,,
UPDATE PLAN ADD SERVICE,,,,,,,,,
UPDATE PLAN ADD SERVICE,,,,,,,,,
FILE 2
<OPERATION_NAME>,<plan_name>,<plan_type>,<service_name>,<is_Default>,MSRP(USD),DISTI(USD),EMEA-MSRP(USD),EMEA-DISTI(USD),
CREATE L2 SUPP PLAN,,,,,,,,,
CREATE L2 SUPP PLAN,,,,,,,,,
<OPERATION_NAME>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>,<pricing_rule>
UPDATE PLAN ADD RATE SCHEDULE,,,,,,,,,
UPDATE PLAN ADD RATE SCHEDULE,,,,,,,,,