PLEASE REMOVE ME FROM YOUR MAILING LIST
THANK YOU
----- Original Message -----
From: "Wade Smart" <[email protected]>
To: <[email protected]>
Sent: Saturday, September 26, 2009 10:47 AM
Subject: Re: [users] number extraction for a formula
Wade Smart wrote:
Harold Fuchs wrote:
265879-09-24-71-918-333-0055
Assuming the "71" part of your string is always in the same position -
two
characters long, starting at the 14th character - and assuming the
strings
are in column A and you want answers in column B, then enter into column
B
the formula
=YEAR(NOW())-1900-VALUE(MID(A1;14;2))
In fact, if your strings are fixed format then using the MID function is
much easier than my previous solution using Regular Expressions.
I get ERROR: 502 when I try this.
On my version of OO I have to use , instead of ; - though I still get the
error.
Question. I looked up Value and it says it converts a text string to a
number. If we are already working on a number, is that needed?
Wade
I took one of the numbers and changed it to text and this worked fine.
But when I change it back to number, it does not.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------------------------------------
Text inserted by Panda GP 2009:
This message has NOT been classified as spam. If it is unsolicited mail
(spam), click on the following link to reclassify it:
http://localhost:6083/Panda?ID=pav_539&SPAM=true&path=C:\Windows\system32\config\systemprofile\AppData\Local\Panda%20Security\Panda%20Global%20Protection%202009\AntiSpam
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
