String Search & Replace?

[Tim Fischer]

I did try it before sending the message and it looks like I can only do
single character replacement which wouldn't work as I need to escape the
quote.  I'm wondering if there is a way to bypass this?

Tim Fischer

> -----Original Message-----
> From: Scott Steinhard [mailto:ssteinhard at GreatParks.org]
> Sent: Thursday, November 04, 2004 9:42 AM
> To: 'tim.fischer at trinitytransport.com'
> Subject: RE: String Search & Replace?
> 
> Try it and find out.
> 
> "Genius is 99% perspiration and 1% inspiration", Henry Ford.
> 
> -----Original Message-----
> From: Tim Fischer [mailto:tim.fischer at trinitytransport.com]
> Sent: Thursday, November 04, 2004 9:19 AM
> To: 'filePro mailing list'
> Subject: String Search & Replace?
> 
> 
> I'm running into an issue where I need to take all the "'s out of a string
> and replace them with \".  It needs to be entirely dynamic as I don't know
> where in the string the "'s will be.
> 
> I've checked the xlate statement, but it looks like I can only do single
> character replacement (is this true?) which wouldn't work as I need to
> escape the quote.
> 
> Obviously, I could use the mid() statement in a huge loop, but with the
> amount of fields - and the size of fields, I'd end up taking too large of
> a
> performance hit.
> 
> Any ideas?
> 
> Tim Fischer
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004