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
The HTML address Tag
The address tag is used to present an address to the site user. It also makes the address available to website search engines.
Rotate
The CSS 'rotate' property is a versatile way to rotate elements.
Building a URL to Self With PHP
PHP has all the parts to build the URL it was accessed with.
Easier Field Information Change
How to "select the field when the field is tapped into" for your own forms.
File Uploader
This file uploader is complete as one PHP script. No external modules or classes are required. Optional login for private use.
Fun Jumper
This fun jumper is easy to implement. Paste the code into one of your web pages. When you are ready to define your own content, replace the image tag.
The HTML optgroup Tag
The HTML <optgroup> tag allows you to group items in a dropdown list.
