creating a data clean up process

Hi, I am trying to create a process which will go through my entire system and auto-populate a new attribute. For example:

If Bo.ShortTitle is undefined, then BO.ShortTitle=ThisBO.Title truncated to first 20 Chars.

Two questions on this:

Is there a truncate function or if I make the short title only 20 chars will that happen automatically?
How do I get a process to affect all records, so far I've only figured out how to do one at a time. I was hoping to run this one-time in the background then remove it.

ugh, wrong forum topic. Sorry.

If it's a one-off process you might be better off doing it directly in the database using SQL. Otherwise, do this:

1) Add your rule to the object
2) Write a process that looks like this:
FIND ALL BO IN BATCHES OF 5
UPDATE BO