Cut & Paste last five characters of a field

[life036]

Hi Everyone,

I'd like to create a script that would cut the last five characters from one field, and paste them into another, then repeat the process for all the records.

I remember doing this in the past, but it's been so long. Anyone have any advice?

Thanks,

Chris

[Ender]

Instead of Cut & Paste, you could do two Replace operations. One to put the last five characters into the second field, and one to remove the last five characters from the first. Something like:

Replace [ field2 ; right(field1, 5) ]

Replace [ field1 ; left(field1, length(field1) - 5) ]

Since Replace[] is not undoable, and acts on all records in the found set, you'd better make a backup before trying this.

[life036]

That worked great! Thanks for the help.

Chris