moving text after a word

[jsaltzman]

i have a list of books. each record has 4 fields

title

price

listing id

author

right now each record has the title and author in the title field.

ie:

The Peppered Moth by Drabble, Margaret

what can i do to move all text starting at "by" and ending at the end of the field, into the author field?

[-Queue-]

Set Field ["author", "Right( Title, Length( Title ) - Position( Title, " by ", 1, PatternCount( Title, " by " ) ) - 3 )"]

The PatternCount() portion ensures that only the last " by " is used, allowing for "All By Myself", etc. as a title.

[jsaltzman]

alright thanks! i will try that.