Remove Special Characters

[jrodriguez88]

I have a couple of field which allow users to put phone numbers, employee numbers and etc.  However, Employees will always find ways to put special characters.   I will need a JS to remove all special characters from these fields.  Please help.  

[FlashD]

Hi jrodriguez88,

 

You can refer: https://stackoverflow.com/questions/469357/html-text-input-allows-only-numeric-input

Also please refer below post for handling the id and class names. Always add the JavaScript code in your header and also include jQuery library in it.

 

[jrodriguez88]

Ok.  I have an update form and I will  need to create a function that will execute on update similar to the one below and will need it to check for characters outside the a-z and A-Z and delete them.  Any idea?  

 

 

window.onload = function ()
{
    var passwordField = document.getElementById('EditRecordPASSWORD');
 var confirmationField = document.getElementById('EditRecordPASSWORD@Confirm');
    passwordField.value = '';
    confirmationField.value = '';
};
</script>

 

[Vitalikssssss]

Hi jrodriguez88,

You can use the following snippet of code to remove special characters from a user input:

<script>

function check()  
{  
  var x = document.getElementById("EditRecordYOUR_FIELD").value;
    
  document.getElementById("EditRecordYOUR_FIELD ").value=x.replace(/[^a-zA-Z ]/g, "");  
} 
document.getElementById("caspioform").onsubmit = check;

</script>

Please place this code into the Footer of your Details Datapage.

 

[jrodriguez88]

Thanks!  It works using one field but I have multiple.  

 

I have tried this but it does not strip special characters when I am trying to use it for multiple fields.  Any advice.  

<script>

function check()  
{  
  var x = document.getElementById("EditRecordPHONE_NUMBER").value;

document.getElementById("EditRecordPHONE_NUMBER").value=x.replace(/[^0-9 ]/g, "");  
 
} 
document.getElementById("caspioform").onsubmit = check;

function checkB()
{
var y = document.getElementById("EditRecordMOBILE_NUMBER").value;

document.getElementById("EditRecordMOBILE_NUMBER").value=z.replace(/[^0-9 ]/g, "");  
} 
document.getElementById("caspioform").onsubmit = check;

    

</script>

[Vitalikssssss]

Hi jrodriguez88,

I would suggest combining your functions within a single function.

Here is a code:

<script>

function check()  
{  
  var x = document.getElementById("EditRecordPHONE_NUMBER").value;
  var y = document.getElementById("EditRecordMOBILE_NUMBER").value;
  
  document.getElementById("EditRecordPHONE_NUMBER").value=x.replace(/[^0-9 ]/g, "");  
  document.getElementById("EditRecordMOBILE_NUMBER").value=z.replace(/[^0-9 ]/g, ""); 
 
} 
document.getElementById("caspioform").onsubmit = check;


</script>

Hope this helps.

[GoodBoy]

Hi everyone!

Just to share, there is an online article related to this: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/remove-special-characters-for-input-fields/

[futurist]

Hi all,

sharing this one which might be of help to you:

 

[Kurumi]

Hi! Just wanted to share this solution if you want to read or accept the single quote or apostrophe (') in the formula: https://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-a-single-quote-in-mysql

Example:

Replace([@field:FIELDNAME], 'Can''t found the name', 'Remove name')