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
JavaScript-Formatted Date and Time
A JavaScript function to publish date/time according to your custom format.
Friendly Anchor Link
How to insert a bit of space above a normal anchor link scroll position.
Form Field Prefill With a Tap
When a link is tapped, a form field is filled in.
Beacon
Send a beacon to your script. Optionally, also send information.
Digging for an IP Address
While an app's IP address can always be found in the REMOTE_ADDR value, the value might not be the actual destination of the content retrieved from your website.
Simple CSS Rotate
Rotate divs, tables, and even characters. Specify the number of degrees or fraction of a turn, and you're good to go.
Avoid Expired SSL Certificate
Check the expiration date of your domain's SSL certificate
