AX / D365FO – Remove spaces from Text in Ax (TRIM)

To Remove spaces from Text you can get idea from below code sample. Here we are update name fields which include spaces on right and left side .

 Dirpartytable   Dirpartytable;  
   Name Name;  
   ;  
   while select forUpdate Dirpartytable  
   {  
     ttsBegin;  
     Name= strRTrim(strLTrim(Dirpartytable.Name));  
     Dirpartytable.Name = Name;  
     Dirpartytable.doUpdate();  
     ttsCommit;  
   }  
   info("Done");