What would be the best way to format and clean a field with Instagram URLs?
I have a CRM built on Airtable and one of the fields is the contact’s instagram details. But some of them have been entered as ‘@myinstagram’, some simply as ‘myinstagram’ and some as ‘https://instagram.com/instagram’.
What would be the best way to format all of them as URLs?
Thank you!