I've been struggling with how to alter old records to comply with new pattern change ?
What happens when you run the script? Is this a one time clean up? If yes, you do not need a script. Either use Find/Replace or do a search for Nik and replace with Nick or do a search for Jus and replace with Justin.
The disabled Replace Field Contents step will do the job without the need for a loop. You are correct that it modifies every record in your found set. You can also do the same from the Edit menu and not use a script if this is a one time fix.
Substitute does have one key limitation that can keep this from working perfectly: It's case sensitive. If you use substitute to replace "Jus" with "Justin", it won't change an entry with "JUS".
Note also that "Jus" is also found int "Justin" so entries with "Justin" will be changed to "Justintin"
"whole words only" is essential, boy did I make a mess without it.
Find & Replace is fast and efficient BUT ?
how do best I replace "NT" with "Nick" & ¶ & "Tom"
"NJT" with "Nick" & ¶ & "Justin" & ¶ & "Tom"
OK, figured it out.
copy replacement string with hidden character(s) and paste it into "replace with field"
Retrieving data ...