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
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.
CSV to HTML Table
Create an HTML table from a CSV file.
Image Transparency
An image can be given a degree of transparency with the CSS opacity property.
Finding Div's Top-Left Corner Position
The coordinates of any type of HTML element can be determined.
Silent Notes
Once implemented, this system is a nice logger when occurrences of extra-important events on a web page need to be counted.
