Forum Discussion

SelmaA's avatar
SelmaA
Copper Contributor
Mar 13, 2023

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 managed to format JSON.  

I have a SharePoint online list with columns. One of the columns is a text field with a social security number. I want my numbers to be be display this way : x xx xx xx xxx xxx xx

 

Is it something that can be done in SharePoint ? If so, how can I achieve that ?

 

Thank you very much !

Selma

 

 

  • 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

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor

    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

    • SelmaA's avatar
      SelmaA
      Copper Contributor
      Thank you very much !!
      Selma

Resources