SET DEFINE OFF;
--SQL Statement which produced this data:
--
--  select * from test;
--
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT3)
 Values
   ('K~D~L~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'JB  ~XYZ~TYFS~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'FAY~KFD~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(JB-FAY)-XYZ-(KFD-TYFS)', 'XYZ-(KFD-TYFS)', 
    '(JB-FAY)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT4)
 Values
   ('1~J~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'XYZ~KOU~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'PODEN~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', 'XYZ-(PODEN-KOU)', 'XYZ', 
    '(PODEN-KOU)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2)
 Values
   ('R~7~D~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'SRC~XYZ~ACR~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'FLH~ABRD~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(SRC-FLH)-XYZ-(ABRD-ACR)', '(SRC-FLH)-XYZ-(ABRD-ACR)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT4)
 Values
   ('G~1~2~J~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'BNS~XYZ~YSW~RANDI~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'CHG ~BORG~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(BNS-CHG)-XYZ-(BORG-YSW)-(RANDI)', '(BNS-CHG)-XYZ-(BORG-YSW)', 
    '(RANDI)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT3)
 Values
   ('K~S~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'DC  ~XYZ~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~', '~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(DC)-XYZ', 'XYZ', 
    '(DC)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT3)
 Values
   ('K~S~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'CRX ~XYZ~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'CHG ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(CRX-CHG)-XYZ', 'XYZ', 
    '(CRX-CHG)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT4)
 Values
   ('R~6~J~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'VSV ~XYZ~MC  ~    ~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'POCH ~TAUNT~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(VSV-POCH)-XYZ-(TAUNT-MC)', '(VSV-POCH)-XYZ', 
    '(TAUNT-MC)');
Insert into TEST
   (INPUTFIELD1, INPUTFIELD2, INPUTFIELD3, OUTPUT1, OUTPUT2, 
    OUTPUT3, OUTPUT4)
 Values
   ('K~S~1~J~ ~ ~ ~ ~ ~ ~ ~ ~ ~', 'CWR~XYZ~LSR~MRP~    ~    ~    ~    ~    ~    ~    ~    ~    ~', 'CHOD~FLIN~PAIN~     ~     ~     ~     ~     ~     ~     ~     ~     ~     ~', '(CWR-CHOD)-XYZ-(FLIN-LSR)-(PAIN-MRP)', 'XYZ-(FLIN-LSR)', 
    '(CWR-CHOD)', '(PAIN-MRP)');
COMMIT;