echodoc
-
Posts
5 -
Joined
-
Last visited
Everything posted by echodoc
-
function in existing records
echodoc replied to echodoc's topic in Calculation Engine (Define Fields)
Thanks! Got it. quote: Originally posted by Chuck: You can either choose replace from the Records menu, or you can put a Replace script step in a ScriptMaker script. Chuck -
function in existing records
echodoc replied to echodoc's topic in Calculation Engine (Define Fields)
One more question. Please excuse my ignorance. Exactly where do I put the Replace function and how do I get it to run? Thanks. -
function in existing records
echodoc replied to echodoc's topic in Calculation Engine (Define Fields)
Thanks! I am going to give it a try. You guys are great! quote: Originally posted by captkurt: Use the Replace function on the existing records. Use the normal LeftWords function in the Replace calculation. -
function in existing records
echodoc replied to echodoc's topic in Calculation Engine (Define Fields)
Thanks. Yours certainly sounds like a more elegant solution for new records, but I'm still left with records already entered the old way. quote: Originally posted by Chuck: My advise would be to reverse the logic. Have users enter the first and last names in separate fields, and then have a field calculate the Last, First format. Chuck [This message has been edited by Chuck (edited November 03, 2000).] -
Is there a way to get a function (LeftWords) to automatically enter data in existing records (eg on exit from the field)? I am trying LeftWords to retrieve the last name from a name field (eg Smith, John) into a newly created LastName field. thanks.