change a word in a field

[Siddiq]

Dear friends

I want to change a word like MALE to FEMALE in a particular field of my database. Please remember the field size is 80 and the word might be at any positon. How to replace it in the all records of database ?

Thanks

 

[bborissov]

** If you want to change MALE to FEMALE
REPLACE YourField WITH STRTRAN(YourField,[ MALE ],[ FEMALE ]) ALL

** If you want to Reverse the field contents:
1. REPLACE YourField WITH STRTRAN(YourField,[ FEMALE ],[ MYFEMALE ]) ALL
2. REPLACE YourField WITH STRTRAN(YourField,[ MALE ],[ FEMALE ]) ALL
3. REPLACE YourField WITH STRTRAN(YourField,[ MYFEMALE ],[ MALE ]) ALL

(not tested well)

Borislav Borissov

 

[alvechurchdata]

Changing "MALE" to "FEMALE" will make the field two characters longer. If the field is close to its maximum length already then you might lose the last characters.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Olaf Doschke]

Hi Borislav,

I also haven't tested, but this surely will have problems with fieldvalues starting "MALE ...". But without the spaces around MALE and FEMALE it would even be worse:

FEMALE->MYFEMALE->MYFEFEMALE

Like always, FEMALES are harder to deal with, especially if you want to make them your own ;-).

By the way, Siddiq, [] are string delimiters too, like ' and ".

If you want values LIKE "MALE %" or LIKE "% MALE" to be translated to "FEMALE %" / "% FEMALE" respectively, you'd need all these three REPLACEs:

REPLACE YourField WITH STRTRAN(YourField,[MALE ],[FEMALE ]) ALL
REPLACE YourField WITH STRTRAN(YourField,[ MALE ],[ FEMALE ]) ALL
REPLACE YourField WITH STRTRAN(YourField,[ MALE],[ FEMALE]) ALL

It's important that the replacement of [MALE ] is done first, or else you'd end up with FEFEMALE. You'd very seldom have the situation with [ MALE], as that would mean the field length is used fully and the value ends with MALE. Then you'd surely end up with [%FEMA].

Bye, Olaf.

 

[Olaf Doschke]

Nonsense.

That's better (with FOR-Clauses):

REPLACE YourField WITH STRTRAN(YourField,[MALE ],[FEMALE ]) for LIKE("MALE*",Yourfield)
REPLACE YourField WITH STRTRAN(YourField,[ MALE ],[ FEMALE ]) ALL
REPLACE YourField WITH STRTRAN(YourField,[ MALE],[ FEMALE]) for LIKE("*MALE",Yourfield)

Bye, Olaf.

 

[Siddiq]

Thanks friends.

I applied STRTRAN and it is working perfectly ... once again thanks