Monthly Archives: April 2015
Validate Asset number using Sharepoint column validation
In our organization asset numbers are printed in these formats:
03 XXXX
03 XXXXX
77 XXXX
77 XXXXX
A need arised to fill those numbers into sharepoint (printer toner consumption app), but without the space at the 3 place.
This is the validation formula for that:
=KDYŽ((JE.CHYBHODN(NAJÍT(” “;[Výdej pro HIM]))); KDYŽ(DÉLKA([Výdej pro HIM])>5; KDYŽ(JE.ČISLO([Výdej pro HIM]+0); KDYŽ(ZLEVA([Výdej pro HIM];2)=”03″; 1; ZLEVA([Výdej pro HIM];2)=”77”) ;0) ;0) ;0)
which translates into:
if input does not contain space then
if length of input is > 5 then
if input IsNumber then
if two leftmost charecters="03" then
return true
else
if two leftmost charecters="77"
return true
else
return false
else return false
else return false
else return false
How to Use ‘OR’ Type Options in SharePoint 2010 Column Validation | PremierPoint Solutions
IF(ISERROR( ((LEN([ZIP Code])=5) +(CODE(MID([ZIP Code],1,1))>47) +(CODE(MID([ZIP Code],1,1))47) +(CODE(MID([ZIP Code],2,1))47) +(CODE(MID([ZIP Code],3,1))47) +(CODE(MID([ZIP Code],4,1))47) +(CODE(MID([ZIP Code],5,1))47) +(CODE(MID([ZIP Code],1,1))47) +(CODE(MID([ZIP Code],2,1))<58)
via How to Use ‘OR’ Type Options in SharePoint 2010 Column Validation | PremierPoint Solutions.
Powercli – How to get Vmware tools version | Virtual Me
get-vm | where {$_.powerstate -ne “PoweredOff” } | where {$_.Guest.ToolsVersionStatus -ne “guestToolsCurrent”} | % { get-view $_.id } | select Name, @{ Name=”ToolsVersion”; Expression={$_.config.tools.toolsVersion}}, @{ Name=”ToolStatus”; Expression={$_.Guest.ToolsVersionStatus}}
via Powercli – How to get Vmware tools version | Virtual Me.