Saturday, December 31, 2016

Remove spaces from Text in Ax 2012

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");