Search and replace text in CSV file

[montypython1]

Greetings,

I am trying to search a "CSV" file to replace specific characters with different characters (ex: replace 'BELLEVUE' with 'AAAAAAAAAA'). I checked the Tek-Tips archives, I found what I was after (thread184-1050184), but have not been able to make it work.

I must be overlooking something ... the code seems rather straightforward (see below):

**********************************************
lcMyString = FILETOSTR('tables\1on1fi quotes.csv')
WAIT WINDOW 'converting file ... please wait' NOWAIT
STRTRAN(lcMyString , 'BELLEVUE' , 'AAAAAAAAAA')
STRTOFILE(lcMyString , 'tables\1on1fi quotes new2.csv')
?lcMyString
**********************************************

FILETOSTR does convert the file to a text string, and STRTOFILE does successfully convert it back to a file, but STRTRAN does NOT find and replace the characters that I have requested.

Any ideas?

Thanks,
Dave

 

[mmerlinn]

[ ]

The arguments in STRTRAN are case-sensitive. Are you sure that "BELLEVUE" is in upper case in the file?

mmerlinn

http://mmerlinn.com

"Political correctness is the BADGE of a COWARD!"

 

[Olaf Doschke]

You need to store the STRTRAN result back to the string var. Your code works, but the result of STRTRAN is going nowhere...

lcMyString = STRTRAN(lcMyString , 'BELLEVUE' , 'AAAAAAAAAA')

Bye, Olaf.

 

[mmerlinn]

[ ]
Olaf is correct. Unless you update lcMyString there is no way it can work. All you are doing is saving the unchanged original string.

Don't know how I missed that.


mmerlinn

http://mmerlinn.com

"We've found by experience that people who are careless and sloppy writers are usually also careless and sloppy at thinking and coding. Answering questions for careless and sloppy thinkers is not rewarding." - Eric Steven Raymond

 

[montypython1]

Thank you Olaf and Mmerlinn,

Your suggestion worked perfectly!
I knew that it would be something simple that I was omitting.

Thank you both,
Dave

 

[Mike Lewis]

Mmerlinn,

Don't know how I missed that.

It's easy to do. I made exactly the same mistake a while ago. I really kicked myself when it dawned on me.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk