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...

Lists

SharePoint Online

SvenSieverding

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