Editing Part of a delimited message in a field

[Neophytus]

I'm fairly new to SQL, but I'm writing a script to edit about 15 tables and 75 fields. 2 of the fields I need to edit contains a delimited message to be sent to another machine. It looks like this:

PAD|SOURCE|DESTINATION|200

The Source and Destination parts would contain computer names. I need to know how to edit only the source and destination names between the pipe-delimiters while leaving the rest of the message alone (Besides manually typing in every single message)....

Thanks for your help

 

[qyllr]

hello,

this is really easy with regex in perl... if you are interested in this solution go do a google search on cpan and check out patterm matching and regular expressions...

if you want a sample script let me know... i'll post one...

hth,
q.

 

[Neophytus]

posting the Perl script may help... I'm not sure though cause I've never used Perl. So if you need another application to run it besides ASA, I probably won't have it.