Change part of a value

[WelshyWizard]

Hi all,

I have a table which contains a column full of values like 959001001
959002001 etc...

I would like to replace 959 with 958.

Does anyone know how to do this?

Cheers

Today is the tomorrow you worried about yesterday - and all is well.....

 

[TonyMcGuire]

Text field?

Scan the table with a tcursor, and replace.

tc.open(":alias:tablename.db")
tc.edit()
scan tc :
  ; # of chars don't matter, Paradox uses up to that #
  tc."fieldname"="958"+tc."fieldname".substr(4,20)

  try
    tc.unlockrecord()
  onfail
    ; PLEASE do error checking here!
    errorclear()
  endTry
endscan
tc.endedit()
tc.close()

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[TonyMcGuire]

A warning: don't try the scan if the field you are working to convert is a sort field. ie., primary key or secondary key and the table (tcursor) is switchindexed to that secondary index.



Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.