Stripping Invalid Characters From Currency Numbers
When building interactive calculation forms, the form user is frequently required to enter currency amounts.
Currency symbols, commas, spaces, and other characters can wreak havoc with the calculation. The calculation fails, resulting in a script error, or the calculated result is incorrect.
Here is a way to strip invalid characters from string values for 3 different programming languages, Perl, PHP, and JavaScript. All characters except numbers and periods are removed from the value.
Perl:
#!/usr/bin/perl
use strict;
print "Content-type:text/html\n\n<head><body>";
my $teststring = '$24,150.85';
print "Before: $teststring<br >";
$teststring =~ s/[^\d\.]//g;
print "After: $teststring";
PHP:
<?php
$teststring = '$24,150.85';
echo "Before: $teststring<br />";
if( preg_match('/[&\d\.]/',$teststring) ) { $teststring = preg_replace('/[^\d\.]/','',$teststring); }
echo "After: $teststring";
?>
JavaScript:
<script type="text/javascript">
var teststring = "$24,150.85";
alert("Before: " + teststring);
var re = /[^\d\.]/g;
teststring = teststring.replace(re,"");
alert("After: " + teststring);
</script>
Will Bontrager
Was this blog post helpful to you?
(anonymous form)
All information in WillMaster Blog articles is presented AS-IS.
We only suggest and recommend what we believe is of value.
As remuneration for the time and research involved to provide quality links,
we generally use affiliate links when we can.
Whenever we link to something not our own, you should assume
they are affiliate links or that we benefit in some way.
Recent Articles in the Library
Download Link for Any File Type
Any file type can be downloaded with this link.
Secret Image File
An image can be loaded into a web page with its source URL never revealed.
Password Eye
All the code that is needed to implement an eye icon for a password field is here. Vital particulars have been addressed.
A Facebook Trick
How to make Facebook's bot rescan your page when you post or reply.
Form Debugging Assistant
Form Debugging Assistant is a handy tool. If you keep the JavaScript in a file on your server, it can be pulled into a web page whenever you need to debug a form.
Make Smaller Copy of Image
The MakeSmallerCopyOfImage function can be placed into your PHP scripts. It is designed to make a copy of an image and reduce its size.
Tap to Select
Making it easy for your site visitors to select content they probably will want to copy is a gesture of friendliness.
