select id, name from compounds where name like '%;%mol%';
Gives a weird list of names. The names should not be replaced but rather the end part after the colon should be replaced.
I think we can do this in a straightforward SQL query with a PL/SQL block. It does not have to be as part of the load actually.
Just mustn't forget about it.
Cheers,
P
121108 2-Phenyl-N-(6-{2-[2-(6-phenylacetylamino-hexylamino)-ethyldisulfanyl]-ethylamino}-hexyl)-acetamide; Compound with 2 moles of Oxalic acid
121209 1-(3,4-Dimethoxy-phenyl)-2-{6-[2-(2-{6-[2-(3,4-dimethoxy-phenyl)-2-hydroxy-ethylamino]-hexylamino}-ethyldisulfanyl)-ethylamino]-hexylamino}-ethanol; Compound with 4 moles of Oxalic acid
121311 N-(1-Methyl-1H-pyrrol-3-ylmethyl)-N'-[2-(2-{6-[(1-methyl-1H-pyrrol-3-ylmethyl)-amino]-hexylamino}-ethyldisulfanyl)-ethyl]-hexane-1,6-diamine; Compound with 4 moles of Oxalic acid
319649 N-(4-Ethylamino-but-2-enyl)-N'-[4-(4-ethylamino-but-2-enylamino)-but-2-enyl]-but-2-ene-1,4-diamine; with 5 moles of HCl
320033 N-[4-(4-Ethylamino-but-2-enylamino)-butyl]-N'-(4-ethylamino-butyl)-but-2-ene-1,4-diamine; with 5 moles of HCl
320078 N-Ethyl-N'-{4-[4-(4-ethylamino-but-2-enylamino)-but-2-enylamino]-butyl}-but-2-ene-1,4-diamine; with 5 moles of HCl
123810 2-[2-(2-Hydroxy-ethylamino)-ethyl]-5,8-dinitro-benzo[de]isoquinoline-1,3-dione; compound with 5 moles ofsulfuric acid
120703 [6-(Benzo[1,3]dioxol-5-ylmethoxy)-hexyl]-(2-{2-[6-(benzo[1,3]dioxol-5-ylmethoxy)-hexylamino]-ethyldisulfanyl}-ethyl)-amine; Compound with 2 moles of Oxalic acid
120737 [6-(1,4-Dihydro-2H-quinazolin-3-yl)-hexyl]-[2-(2-{[6-(1,4-dihydro-2H-quinazolin-3-yl)-hexyl]-methyl-amino}-ethyldisulfanyl)-ethyl]-methyl-amine; Compound with 6 moles of Oxalic acid
143200 4-Amino-N-[2-(4-benzyl-morpholin-2-yl)-ethyl]-5-chloro-2-methoxy-benzamide; compound with 0.5 mol but-2-enedioic acid
143201 4-Amino-N-(4-benzyl-morpholin-2-ylmethyl)-5-chloro-2-methoxy-N-methyl-benzamide; compound with but-2-enedioic acid and 0.25 mol water
133093 5-Chloro-3-piperidin-4-ylmethyl-1H-indole; 5 moles of fumarate
215406 3-(2-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-oxazolidin-2-one; compound with 2 moles of HCl and 1 mole of H2O
210806 (6-Benzhydryl-piperidin-3-yl)-(3,4-difluoro-benzyl)-amine; compound with 2 moles of oxalic acid
106763 2-(2-Pentyloxy-2,3-dihydro-benzo[1,4]dioxin-2-yl)-4,5-dihydro-1H-imidazole; hydrochloride:1/4 moles H2O
106407 2-[2-(2-Chloro-benzyloxy)-2,3-dihydro-benzo[1,4]dioxin-2-yl]-4,5-dihydro-1H-imidazole; hydrochloride: 3/4 moles H2O
121107 1,2-bis-(2-Amino-N-(6-ethylamino-hexyl)-benz amide) disulphide; Compound with 4 moles of Hydrochloric acid
121153 2-{6-[2-(2-{6-[2-Hydroxy-2-(3-methoxy-phenyl)-ethylamino]-hexylamino}-ethyldisulfanyl)-ethylamino]-hexylamino}-1-(3-methoxy-phenyl)-ethanol; Compound with 3 moles of Oxalic acid
315466 4-(acetylamino)-3-[[(aminoiminomethyl)hydrazino]-methyl]benzoic acid; with 2 moles of H2O
315476 4-[2-[[(Aminoiminomethyl)amino]imino]ethyl]benzoic acid; with 0.25 moles of H2O
120784 1-Benzo[1,3]dioxol-5-yl-2-[6-(2-{2-[6-(2-benzo[1,3]dioxol-5-yl-2-hydroxy-ethylamino)-hexylamino]-ethyldisulfanyl}-ethylamino)-hexylamino]-ethanol; Compound with 3 moles of Oxalic acid
215250 1-(2-{4-[3-(4-Fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-3-methyl-imidazolidin-2-one; compound with 2 moles of HCl and 1 mole of H2O
215455 3-(2-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-1H-quinazoline-2,4-dione; compound with 0.1 moles of H2O
124043 5,8-Diamino-2-(2-piperidin-1-yl-ethyl)-benzo[de]isoquinoline-1,3-dione; 5 moles of hydrochloride
120888 N-(1H-Indol-3-ylmethyl)-N'-[2-(2-{6-[(1H-indol-3-ylmethyl)-amino]-hexylamino}-ethyldisulfanyl)-ethyl]-hexane-1,6-diamine; Compound with 4 moles of Oxalic acid
121170 tert-Butyl-[2-(2-tert-butylamino-ethyldisulfanyl)-ethyl]-amine; Compound with 2 moles of Hydrochloric acid
121264 (2-Methoxy-benzyl)-[6-(2-{2-[6-(2-methoxy-benzylamino)-hexyloxy]-ethyldisulfanyl}-ethoxy)-hexyl]-amine; Compound with 2 moles of Oxalic acid
144001 N-(4-Benzyl-morpholin-2-ylmethyl)-5-chloro-4-dimethylamino-2-hydroxy-benzamide; compound with oxalic acid and 0.5mol water
320032 N-(4-Ethylamino-but-2-enyl)-N'-[4-(4-ethylamino-butylamino)-butyl]-but-2-ene-1,4-diamine; with 5 moles of HCl
320147 N-(4-Ethylamino-butyl)-N'-[4-(4-ethylamino-butylamino)-but-2-enyl]-but-2-ene-1,4-diamine; with 5 moles of HCl
171917 2-Naphthalen-2-yl-1-(4-phenyl-piperazin-1-yl)-ethylideneamine; hydrochloride,1/2 mole of H2O
172659 2-Naphthalen-2-yl-1-(4-phenyl-piperidin-1-yl)-ethylideneamine; hydrochloride,1/2 mole of H2O
372645 Sodium; 5-[3-(2-carboxy-4-oxo-4H-chromen-5-yloxy)-2-hydroxy-propoxy]-4-oxo-4H-chromene-2-carboxylate(cromolyn sodium)
106683 2-(2-Methyl-2,3-dihydro-benzo[1,4]dioxin-2-yl)-4,5-dihydro-1H-imidazole; hydrochloride:1/4 moles H20
319615 N-Ethyl-N'-{4-[4-(4-ethylamino-but-2-enylamino)-butylamino]-butyl}-but-2-ene-1,4-diamine; with 5 moles of HCl
106366 2-[2-(4-Chloro-benzyloxy)-2,3-dihydro-benzo[1,4]dioxin-2-yl]-4,5-dihydro-1H-imidazole; hydrochloride: 3/4 moles H2O
121277 (6-Piperidin-1-yl-hexyl)-{2-[2-(6-piperidin-1-yl-hexylamino)-ethyldisulfanyl]-ethyl}-amine; Compound with 4 moles of Oxalic acid
121303 (6-Benzyloxy-hexyl)-{2-[2-(6-benzyloxy-hexylamino)-ethyldisulfanyl]-ethyl}-amine; Compound with 2 moles of Hydrochloric acid
172513 N-Isopropyl-2-naphthalen-2-yl-acetamidine; hydrochloride,1 mole of H2O
143913 N-(4-Benzyl-morpholin-2-ylmethyl)-5-chloro-2-methoxy-4-methylamino-benzamide; compound with but-2-enedioic acidand 0.5mol of water
372103 4-Allyl-3,4,5,6-tetrahydro-2H-1,5-methano-benzo[e][1,4]diazocin-9-ylamine; compound with 2 moles of ethanesulfonic acid
215815 3-(2-{4-[3-(4-Fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-1H-quinazoline-2,4-dione; compound with 2 moles of HCl
216084 1-(2-{4-[3-(4-Hydroxy-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-imidazolidin-2-one; compound with 0.4 moles of H2O
315726 3-[[Amino(cyanoimino)methyl]amino]benzoic acid; with 0.25 moles of H2O
121384 N-Phenethyl-N'-{2-[2-(6-phenethylamino-hexylamino)-ethyldisulfanyl]-ethyl}-hexane-1,6-diamine; Compound with 3 moles of Oxalic acid
143542 N-(4-Benzyl-morpholin-2-ylmethyl)-5-chloro-4-dimethylamino-2-ethoxy-benzamide; compound with oxalic acid and 0.25mol water
106628 2-(2-Vinyl-2,3-dihydro-benzo[1,4]dioxin-2-yl)-4,5-dihydro-1H-imidazole; hydrochloride1/4 moles H20
215423 1-(2-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-3-isopropyl-imidazolidin-2-one; compound with 2 moles of HCl
215507 1-(2-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-3-methyl-imidazolidin-2-one; compound with 2 moles of HCl
216421 1-(2-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-pyrrolidin-2-one; compound with 2 moles of HCl
216452 1-(2-{4-[3-(4-Fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-imidazolidin-2-one; compound with 0.3 moles of H2O
106414 2-[2-(4-Methoxy-benzyloxy)-2,3-dihydro-benzo[1,4]dioxin-2-yl]-4,5-dihydro-1H-imidazole; hydrochloride:1/4 moles H2O
393655 2-[11-[3-amino(imino)methylaminopropyl]-19-(5-aminopentylcarboxamido)-14-isopropyl-12-methyl-4,7,10,13,16-pentaoxo-(5S,11S,14R)-3,6,9,12,15-pentaazabicyclo[15.3.1]henicosa-1(21),17,19-trien-5-yl]acetic acid; Two molecules of trifluoro-acetic acid
319647 N-Ethyl-N'-{4-[4-(4-ethylamino-butylamino)-butylamino]-butyl}-but-2-ene-1,4-diamine; with 5 moles of HCl
109643 8-(4,5-Dihydro-thiazol-2-ylsulfanyl)-2-[(2,2-dimethyl-cyclopropanecarbonyl)-amino]-oct-2-enoic acid; compound with 0.036moles of methylnitrate.
121154 N-(2,3-Dihydro-benzo[1,4]dioxin-2-ylmethyl)-N'-[2-(2-{6-[(2,3-dihydro-benzo[1,4]dioxin-2-ylmethyl)-amino]-hexylamino}-ethyldisulfanyl)-ethyl]-hexane-1,6-diamine; Compound with 4 moles of Hydrochloric acid
121207 [6-(4H-Benzo[e][1,3]oxazin-3-yl)-hexyl]-(2-{2-[6-(4H-benzo[e][1,3]oxazin-3-yl)-hexylamino]-ethyldisulfanyl}-ethyl)-amine; Compound with 4 moles of Oxalic acid
143685 N-(4-Benzyl-morpholin-2-ylmethyl)-2-methoxy-benzamide; compound with 2mol but-2-enedioic acid
121168 1,2- bis-(1-Ethyl-piperidine) disulphide; Compound with 2 moles of Hydrochloric acid
121171 1,2-bis-(4-[2-(6-Ethylamino-hexylamino)-1-hydroxy-ethyl]-1,2-dihydroxy-benzene) disulphide; Compound with 4 moles of Hydrochloric acid
106764 2-[2-(4-Methoxy-phenoxy)-2,3-dihydro-benzo[1,4]dioxin-2-yl]-4,5-dihydro-1H-imidazole; hydrochloride: 1/2 moles H2O
172626 1-(4-Methyl-piperazin-1-yl)-2-naphthalen-2-yl-ethylideneamine; hydrochloride,1/2 mole of H2O
120638 N-(2-Amino-benzyl)-N'-(2-{2-[6-(2-amino-benzylamino)-hexylamino]-ethyldisulfanyl}-ethyl)-hexane-1,6-diamine; Compound with 6 moles of Hydrochloric acid
120705 Methyl-(2-{2-[methyl-(6-pyrrolidin-1-yl-hexyl)-amino]-ethyldisulfanyl}-ethyl)-(6-pyrrolidin-1-yl-hexyl)-amine; Compound with 4 moles of Hydrochloric acid
120782 2-{6-[2-(2-{6-[2-Hydroxy-2-(4-methoxy-phenyl)-ethylamino]-hexylamino}-ethyldisulfanyl)-ethylamino]-hexylamino}-1-(4-methoxy-phenyl)-ethanol; Compound with 4 moles of Oxalic acid
120783 2-{6-[2-(2-{6-[2-Hydroxy-2-(2-methoxy-phenyl)-ethylamino]-hexylamino}-ethyldisulfanyl)-ethylamino]-hexylamino}-1-(2-methoxy-phenyl)-ethanol; Compound with 4 moles of Oxalic acid
365544 (S)-5-Amino-2-[((S)-2-amino-3-phenyl-propionyl)-methyl-amino]-pentanoic acid naphthalen-2-ylamide; 2 moles of trifluoroacetic acid
121205 [6-(2,3-Dihydro-indol-1-yl)-hexyl]-(2-{2-[6-(2,3-dihydro-indol-1-yl)-hexylamino]-ethyldisulfanyl}-ethyl)-amine; Compound with 2 moles of Oxalic acid
215802 3-(2-{4-[3-(4-Fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-oxazolidin-2-one; compound with 2 moles of HCl
319648 N-(4-Ethylamino-butyl)-N'-[4-(4-ethylamino-butylamino)-butyl]-but-2-ene-1,4-diamine; with 5 moles of HCl
121172 2-{6-[2-(2-{6-[2-Hydroxy-2-(3,4,5-trimethoxy-phenyl)-ethylamino]-hexylamino}-ethyldisulfanyl)-ethylamino]-hexylamino}-1-(3,4,5-trimethoxy-phenyl)-ethanol; Compound with 4 moles of Oxalic acid
121271 [2-(2-Diethylamino-ethyldisulfanyl)-ethyl]-diethyl-amine; Compound with 2 moles of Hydrochloric acid
144316 Benzo[1,3]dioxole-4-carboxylic acid (4-benzyl-morpholin-2-ylmethyl)-amide; compound with but-2-enedioic acid and 0.25mol water
106875 2-(2-m-Tolyloxy-2,3-dihydro-benzo[1,4]dioxin-2-yl)-4,5-dihydro-1H-imidazole; hydrochloride: 1/4 moles H2O
120785 2-[6-(2-{2-[6-(2-Hydroxy-2-phenyl-ethylamino)-hexylamino]-ethyldisulfanyl}-ethylamino)-hexylamino]-1-phenyl-ethanol; Compound with 4 moles of Oxalic acid
120566 [6-(2-Methoxy-benzyloxy)-hexyl]-(2-{2-[6-(2-methoxy-benzyloxy)-hexylamino]-ethyldisulfanyl}-ethyl)-amine; Compound with 2 moles of Oxalic acid
120706 Methyl-(2-{2-[methyl-(6-piperidin-1-yl-hexyl)-amino]-ethyldisulfanyl}-ethyl)-(6-piperidin-1-yl-hexyl)-amine; Compound with 4 moles of Hydrochloric acid
215868 1-(2-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-1,3-dihydro-benzoimidazol-2-one; compound with 2 moles of HCl
143587 4-Amino-N-[3-(4-benzyl-morpholin-2-yl)-propyl]-5-chloro-2-methoxy-benzamide; compound with oxalic acid and 0.5mol of water
142956 N-(4-Benzyl-morpholin-2-ylmethyl)-5-chloro-4-dimethylamino-2-methoxy-benzamide; compound with 0.75mol but-2-enedioic acid and 0.25mol water
121169 Benzyl-[2-(2-benzylamino-ethyldisulfanyl)-ethyl]-amine; Compound with 2 moles of Hydrochloric acid
121206 [6-(3,4-Dihydro-1H-isoquinolin-2-yl)-hexyl]-(2-{2-[6-(3,4-dihydro-1H-isoquinolin-2-yl)-hexylamino]-ethyldisulfanyl}-ethyl)-amine; Compound with 4 moles of Oxalic acid
121238 Benzyl-(6-{2-[2-(6-benzylamino-hexyloxy)-ethyldisulfanyl]-ethoxy}-hexyl)-amine; Compound with 2 moles of Oxalic acid
121309 (6-Pyrrolidin-1-yl-hexyl)-{2-[2-(6-pyrrolidin-1-yl-hexylamino)-ethyldisulfanyl]-ethyl}-amine; Compound with 4 moles of Oxalic acid
125064 5,8-Diamino-2-(2-dimethylamino-ethyl)-benzo[de]isoquinoline-1,3-dione; 3 moles of hydrocholride
106369 2-(3-Methyl-2,3-dihydro-benzo[1,4]dioxin-2-yl)-4,5-dihydro-1H-imidazole; hydrochloride:1 moles H2O
144276 Benzo[1,3]dioxole-5-carboxylic acid (4-benzyl-morpholin-2-ylmethyl)-amide; compound with 0.75mol but-2-enedioic acid
215414 1-Ethyl-3-(2-{4-[6-fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-imidazolidin-2-one; compound with 2 moles of HCl
215889 3-(3-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-propyl)-oxazolidin-2-one; compound with 2 moles of HCl
120403 N-(2-Amino-benzyl)-N'-[2-(2-{[6-(2-amino-benzylamino)-hexyl]-methyl-amino}-ethyldisulfanyl)-ethyl]-N'-methyl-hexane-1,6-diamine; Compound with 6 moles of Hydrochloric acid
171921 2-(1-Chloro-naphthalen-2-yl)-1-pyrrolidin-1-yl-ethylideneamine; hydrochloride,1 mole of H2O
320079 N-[4-(4-Ethylamino-but-2-enylamino)-but-2-enyl]-N'-(4-ethylamino-butyl)-but-2-ene-1,4-diamine; with 5 moles of HCl
216312 1-(3-{4-[6-Fluoro-3-(4-fluoro-phenyl)-indan-1-yl]-piperazin-1-yl}-propyl)-imidazolidin-2-one; compound with 2 moles of HCl
216337 1-(2-{4-[3-(4-Chloro-phenyl)-indan-1-yl]-piperazin-1-yl}-ethyl)-imidazolidin-2-one; compound with 2 moles of HCl
168527 (R)-7-[4-(4-Methyl-piperazin-1-yl)-cyclohexyl]-5-(4-phenoxy-phenyl)-7H-pyrrolo[2,3-d]pyrimidin-4-ylamine; Compound with 3 moles of maleate
