SharePoint MA -- avoid the noise

June 28, 2016

In using the SharePoint MA from Steve Kean I noticed that some of the fields I imported were coming in with some extra noise or crap at the beginning:


All I really wanted was the 164. While I can use the Word function in a sync rule to get past it
Word(strAttribute,2,“2”) I really would prefer to bypass it altogether.

Well thanks to Jermaine Snipe I found why this happens and how to bypass it:
These are calculated columns and they use the concatenate function. Instead use a Text formula for the calculated column. This of course supposes that you can get the SharePoint developer to change it.