We have a CLOB column in our PNR database with the complete PNR details as below (all information has been changed ):
<PNR><PNR_Body>AXYDFB -ETKT-
REC LOC HDQ1P37EJNM/XAV/24639860/CHI/1P/T/US/USD/GS
HDQ RM 1P 01OCT0000Z
1.1TEST/ONE
1 VS3011N 14DEC SA LHREDI HK1 1950. 2120. 03C*
2 VS3002N 18DEC WE EDILHR HK1 0910. 1040. 03C*
FONE-
1.LHR*MES.TESTONE@UBM.COM/N000
2.LHR72582/H530
3.LHR8200144*I24639860 ORBITZ/A877
4.LHR3072582/H415
TKT-T/TBC/CCAX379461823464012/12/72601233655/0001/$
GEN FAX- *TKN/SSR FOR TKT NBRS
1.OSI YY BF0.00 TX141.10 TF141.10 PADT@FSR
2.SSRSEATVSKK1LHREDI3011N14DEC.03CN/RS
3.SSRSEATVSKK1EDILHR3002N18DEC.03CN/RS
4.SSROTHSVSKK1LHREDI3011N14DEC.UNTKTD VS SEGS MAY CANX 141013
5.SSROTHSVSKK1LHREDI3011N14DEC.TKT PER FARE RULES TO AVOID ADM
6.SSROTHSVSKK1EDILHR3002N18DEC.UNTKTD VS SEGS MAY CANX 141013
7.SSROTHSVSKK1EDILHR3002N18DEC.TKT PER FARE RULES TO AVOID ADM
8.SSROTHSVSKK1LHREDI3011N14DEC.UNTKTD VS SEGS MAY CANX 141013
9.SSROTHSVSKK1LHREDI3011N14DEC.TKT PER FARE RULES TO AVOID ADM
10.SSROTHSVSKK1EDILHR3002N18DEC.UNTKTD VS SEGS MAY CANX 141013
11.SSROTHSVSKK1EDILHR3002N18DEC.TKT PER FARE RULES TO AVOID ADM
12.SSROTHSVSKK1LHREDI3011N14DEC.UNTKTD VS SEGS MAY CANX 141013
13.SSROTHSVSKK1LHREDI3011N14DEC.TKT PER FARE RULES TO AVOID ADM
14.SSROTHSVSKK1EDILHR3002N18DEC.UNTKTD VS SEGS MAY CANX 141013
15.SSROTHSVSKK1EDILHR3002N18DEC.TKT PER FARE RULES TO AVOID ADM</PNR_Body><PNR_History>REC LOC AXYDFB7EJNM/XAV/24631260/CHI/1P/T/US/USD/GS
HDQ RM 1P 01OCT0000Z
A3 SSRSEATVSNN1LHREDI3011N14DEC.03C/RS
RCVD-AXYDFB7EJNM/XAV/24612860/CHI/1P/T/US/USD/GS
HDQ RM 1P 01OCT0000Z
X3 SSRSEATVSNN1LHREDI3011N14DEC.03C/RS
A3 SSRSEATVSKK1LHREDI3011N14DEC.03CN/RS
RCVD-
HDQ RM 1P 01OCT0000Z
A3 SSRSEATVSNN1EDILHR3002N18DEC.03C/RS
RCVD-AXYDFB7EJNM/XAV/24612860/CHI/1P/T/US/USD/GS
HDQ RM 1P 01OCT0000Z
X3 SSRSEATVSNN1EDILHR3002N18DEC.03C/RS
A3 SSRSEATVSKK1EDILHR3002N18DEC.03CN/RS
RCVD-
HDQ RM 1P 01OCT0000Z
A3 SSROTHSVSKK1LHREDI3011N14DEC.UNTKTD VS SEGS MAY CANX 142313
A3 SSROTHSVSKK1LHREDI3011N14DEC.TKT PER FARE RULES TO AVOID ADM
A3 SSROTHSVSKK1EDILHR3002N18DEC.UNTKTD VS SEGS MAY CANX 142313
A3 SSROTHSVSKK1EDILHR3002N18DEC.TKT PER FARE RULES TO AVOID ADM
RCVD-VSWEBSERVICE
CRC SU X1 01OCT0001Z D23B06 VS
A3 SSROTHSVSKK1LHREDI3011N14DEC.UNTKTD VS SEGS MAY CANX 142313
A3 SSROTHSVSKK1LHREDI3011N14DEC.TKT PER FARE RULES TO AVOID ADM
A3 SSROTHSVSKK1EDILHR3002N18DEC.UNTKTD VS SEGS MAY CANX 142313
A3 SSROTHSVSKK1EDILHR3002N18DEC.TKT PER FARE RULES TO AVOID ADM
RCVD-VSWEBSERVICE
CRC SU X1 01OCT0001Z AXYDFB VS
A3 SSROTHSVSKK1LHREDI3011N14DEC.UNTKTD VS SEGS MAY CANX 142313
A3 SSROTHSVSKK1LHREDI3011N14DEC.TKT PER FARE RULES TO AVOID ADM
A3 SSROTHSVSKK1EDILHR3002N18DEC.UNTKTD VS SEGS MAY CANX 142313
A3 SSROTHSVSKK1EDILHR3002N18DEC.TKT PER FARE RULES TO AVOID ADM
RCVD-VSWEBSERVICE
CRC SU X1 01OCT0001Z D12B06 VS
A3 SSRTKNEVSHK1LHREDI3011N14DEC-1TEST/ONE.4444123456C1
A3 SSRTKNEVSHK1EDILHR3002N18DEC-1TEST/ONE.4444123456C2
RCVD-AXYDFB7EJNM/XAV/24623860/CHI/1P/T/US/USD/GS
HDQ RM 1P 01OCT0042Z</PNR_History><Seating>SEATS ASSIGNED FLT 3011 14DEC HK1 1950. 2120. X CLASS
B7 * 1TEST/JA LHR TO EDI N 28Z*
NEXT FLIGHT AT EDI FLT 3002 18DEC HK1 0910. 1040. N CLASS
B2 * 1TEST/JA EDI TO LHR N 23D*</Seating><ETicket_Info>AXYDFB -ETKT- CPN FLIGHT DATE CLS FRM TO STATUS ISSUE
1. TEST/ONE 1. VS 3011 14DEC N LHREDI 1P
2. VS 3002 18DEC N EDILHR</ETicket_Info><ETicket_History>TEST/ONE 44443333222211110 $USD 141.10
FP CCAX44443333222211110/9306/142323
CHI 1P RS 01OCT0042Z 999999 VS
***END OF DISPLAY*** </ETicket_History><Fare_Quote>NO FQ DATA EXISTS</Fare_Quote><Fare_History>NO FQ DATA EXISTS</Fare_History><APIS>*NO APIS TO DISPLAY</APIS><Queue_History>SYSQ/IET/00
-Q SSRTKNE 01OCT0042Z </Queue_History></PNR>
Please can somebody suggest how I can browse through each row of the data identify credit card numbers (that we will be doing as per the business requirements from business) mask the numbers and put that back at the orignal location as it was.
Please can somebody explain me considering "44443333222211110" was a credit card number and requires to be masked.