Forum Discussion

SelmaA's avatar
SelmaA
Copper Contributor
Mar 13, 2023
Solved

Display text column as a social security number

Hi everyone,    It's been quite some time and I haven't been able to find an answer to my issue. To give some background I am not a developer, however I do work with SharePoint everyday and have ma...
  • SvenSieverding's avatar
    Mar 13, 2023

    Hi SelmaA 

    You can use this, if you have a text column

    {
    "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
    
    "elmType": "span",
    "txtContent": "=substring(@currentField, 0, 1) + ' '+substring(@currentField, 1, 3)+ ' '+substring(@currentField, 3, 5)+ ' '+substring(@currentField, 5, 7)+ ' '+substring(@currentField, 7, 10)+ ' '+substring(@currentField, 10, 13)+ ' '+substring(@currentField, 13, 15)"
    }

     and this, if you have a number column

    {
    "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
    
    "elmType": "span",
    "txtContent": "=substring(toString(@currentField), 0, 1) + ' '+substring(toString(@currentField), 1, 3)+ ' '+substring(toString(@currentField), 3, 5)+ ' '+substring(toString(@currentField), 5, 7)+ ' '+substring(toString(@currentField), 7, 10)+ ' '+substring(toString(@currentField), 10, 13)+ ' '+substring(toString(@currentField), 13, 15)"
    }

     

    Best Regards,

    Sven

Resources