STRTRAN not removing character

[keepingbusy]

Hi

The following is run to remove the character ; from a MEMO field within a table:

VAR3 = COLUMN3
REPLACE COLUMN3 WITH STRTRAN(VAR3, ';', " ")

This works with all other fields in the table but not with COLUMN3 which is a MEMO field.

The process we are using creates a CSV file for upload to a server and this is causing havov with MySQL 5.

Can anyone suggest why this doesn't work for a memo field but does for any other character field?

Thank you guys

Lee

 

[EzLogic]

try chrtran()

Ali Koumaiha
TeknoPCS Inc.
Dearborn heights, MI 48127

 

[keepingbusy]

Hi Ali

ok, the help file gives an example:

? CHRTRAN('ABCDEF', 'ACE', 'XYZ') && Displays XBYDZF
? CHRTRAN('ABCD', 'ABC', 'YZ') && Displays YZD
? CHRTRAN('ABCDEF', 'ACE', 'XYZQRST') && Displays XBYDZF

So if I store the MEMO field to VAR3 how do I get the character ; removed form the field?

Lee

 

[keepingbusy]

Sorry that should have said, "....removed from the field?

 

[jimstarr]

Hi Lee,

Your code works fine for me in a memo field. Is it possible you're meaning to do a REPLACE ALL rather than just REPLACE?

Jim

 

[DSummZZZ]

Your original logic works fine for me.
Is it not repopulating the memo field correctly?
Is there by chance, a table in another work area at EOF()?
Did you test the results - as in,

VAR3 = COLUMN3
VAR3 = STRTRAN(VAR3, ';', " ")
?VAR3
REPLACE COLUMN3 WITH VAR3

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[keepingbusy]

All

If I could show a red face here I would.

The command was being issued BEFORE another field in another table was being replaced. So the ; would have never been removed in a million years.

Now the coding has been "Altered" it works fine.

That's what happens when you inherit someone else's code but no excuses on my part.

Thanks again for your time (hope it wasn't wasted).

Lee

 

[DSummZZZ]

Try this:



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[keepingbusy]

Thank you Dave!

Windows Vista
Visual FoxPro Versions 6 & 9

http://www.customsoftware.co.uk