Format Clean Numbers

Hi all,

In my database, I have tax payer numbers (type text) stored as clean numbers, such as 88888888000100. When users input this data, it appears with an input mask formatted like 88.888888/0001-00.

Now, I want to display the clean number stored in the database (88888888000100) in the format commonly used for tax payer numbers in my country (88.888888/0001-00).

Any suggestions on how to achieve this?

Thank you!

Update: found this topic and managed to do it like so:
image

1 Like