Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find & Replace

Status
Not open for further replies.

woodyinoz

IS-IT--Management
Jan 8, 2002
215
GB
I am looking to run an automatic find and replace on some imported data. I want to replace all X's and -'s with another charcter in order to be able to run filters on them.

Has anyone got any ideas?

Thanks,

Woody.
 
I usually use a text editor to do this (like Wordpad) before I do an import. But that's not automated... Most of the ways I can think of are complicated.

You can probably do something with readLine(), subStr() and writeLine() if the data is in ascii format.

If it's in a table, you are stuck with a scan loop, tCursor and subStr(); or maybe even locatePattern().

Maybe someone else has a better idea.


Mac :)

"Strange women lying in ponds and distributing swords is no basis for a system of government" - Dennis, age 37

mailto:langley_mckelvy@cd4.co.harris.tx.us
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top