martedì, novembre 30, 2010

SharePoint Calculated Field: CLEAN()

Wow. I wish I knew about this function years ago!
=CLEAN([myMessyTextField])
From endusersharepoint.com:
“The “CLEAN()” function is useful when moving data from one type of system to another in that it allows you to remove any characters that do not directly represent a written symbol (“Non-Printing”, or “Control” characters), but rather, represents a specific action or formatting on the data itself. Examples of this would be “line feeds” and “tabs” (or anything that doesn’t fall in the Decimal 32-127 and 128-255 ASCII ranges – “Printable” and “ASCII Extended” respectively – http://www.ascii-code.com).”