Code:
awk '
$1 == SRCH {CNT = $2
PRCU = 1
}
!PRCU {SUM += $2
}
!HDDONE {print
if (/^Home/) HDDONE = 1
next
}
TAGS < SUM {TAGS += NF - 1
print
next
}
CURR < CNT {CURR += gsub (PRFX, REPL)
print
next
}
1
' FS=, SRCH="Pets" PRFX="P" REPL="X" file
N44361,
New Insu,
Men,1,
Women,57,
Kids,65,
Pets,11,
Home,1,
M11,
WP770059634,WP770059639,WP770059644,P770059654,P770059655,P770059656,W770059657,W770059658,W770059659,W770059660,
W770059661,W770059662,W770059663,W770059664,W770059665,W770059666,W770059667,W770059668,W770059669,W770059670,
W770059671,W770059672,W770059673,W770059674,W770059675,W770059676,W770059677,W770059678,W770059679,W770059680,
W770059681,W770059682,W770059683,W770059684,W770492470,W770492472,W770492474,W770755150,W770755151,W770492477,
W770755128,W770755131,W770755132,W770755135,W770755139,W770755140,W770755141,W770755142,W770755143,W770755144,
W770755149,W770755148,W770755147,W770755146,W770755153,W770755154,W5002,
K70059634,K70059639,K70059644,K70059654,K70059655,K70059656,K70059657,K70059658,
K70059659,K70059660,K70059661,K70059662,K70059663,K70059664,K70059665,K70059666,
K70059667,K70059668,K70059669,K70059670,K70059671,K70059672,K70059673,K70059674,
K70059675,K70059676,K70059677,K70059678,K70059679,K70059680,K70059681,K70059682,
K70059683,K70059684,K70492470,K70492472,K70492474,K70755150,K70755151,K70492477,
K70755128,K70755131,K70755132,K70755135,K70755139,K70755140,K70755141,K70755142,
K70755143,K70755144,K70755149,K70755148,K70755147,K70755146,K70755153,K70755154,
K5002,K5007,K5012,K5017,K5022,K5027,K5032,K5037,
K5042,
X300102,X2200,X2201,X2202,X2203,X2204,X2205,X2206,X2207,X2208,
X2209,
P1917079,