12-08-2012 11:12 PM
Is there a SAS function that extracts only the numerals from a straing
if F is a sas function then it should give,
F(1bhy688%<2) = 16882,
F(>%$123abc77 bad guy 88)= 1237788,
F( " 1 5 abc 6 ^* +-? ")=156 and so on ?
12-10-2012 03:31 PM
In the spirit of sharing at Christmas, for my fellow Canadians, this is EXACTLY the function needed to get %$##$#%% gas pumps in the U.S. to accept your credit card. When they ask for a ZIP code, enter your Postal Code, digits only, followed by zeroes to fill to five digits. For example, my postal code is K2P 1S3, I use 21300, it's worked at least ten times on my recent trip. Another small aggravation eliminated, the coincidence of this appearing on the forum the day I get home is quite something.
Merry Christmas, (and even to Americans who create these U.S.-centric applications),
12-10-2012 03:55 PM
: They are probably only collecting the zipcodes for market research purposes and apparently not checking them for validity. There is no 23100 zipcode in the US. The closest I could find (using Google) was:
12-11-2012 04:29 PM
No, this has been causing us grief for years. Before we found this, we had tried many options. They were all rejected, which meant going into the gas station, getting them to turn on the pump, usually leaving our credit card with them, and a whole bunch or rigamarole. The following DON'T work:
Using our postal code, with the numbers for the letter keys;
Using the actual ZIP code of the place we were going.
Based on the last, clearly some kind of edit against our credit card information was being done.
Believe me, someday you'll thank me for this!
Need further help from the community? Please ask a new question.