AnsweredAssumed Answered

Iterating through every record in a field and trimming white space

Question asked by dwirony on Jun 28, 2018
Latest reply on Jun 28, 2018 by ThierryGuemboura

I'm trying to use the following script to replace each value in a field with the Trimmed version of itself. The script runs fine, but I export all records afterwards and I still see white space - am I missing something?

 

Go to Record/Request/Page [First]
Loop
  Exit Loop If [Let($c=$c+1;$c>Get(FoundCount))]
  Set Field [MyDataBase::MyField; Trim ( MyDataBase::MyField )]
  Commit Records/Requests [With dialog:On]
End Loop

Outcomes