Regular Expression to detect repeating decimal?
Can a regular expression detect a repeating decimal?
For example, given these input numbers, can a regex return these
1.232323 -> returns "23"
1.23456789789789 -> returns "789" (ignores the "23456" before the
1.1371371 -> returns "137" (not 371)
1.13713713 -> returns "137" (not 713)
If a regex can't do all of the work, can it do part of the work,
supplemented by other code?
Greg Lovern wrote on 13 jan 2010 in microsoft.public.scripting.vbscript:
...Error message needed if incorrect Date Of Birth (DOB) entered
In cell D6 I have a DOB entered....in cell E6 I have a datedif function that
has 3 conditional formatting set as:
1 - If D6 is blank, E6 is blank.
2 - If DOB in D6 is between 18 - 24 then E6 shows age and cell is yellow.
3 - If DOB in D6 is 25 or over then E6 shows age and cell is blue.
What I need is when a DOB is entered in D6 under 16 years old, then D6
returns an error message -" You have Entered an Age under 16 Years - Retry!!
I have tried Data Validation, but cant get a message from tha as I dont know
what to set as the date validation.
I do need a...Error during Exchange Backup
I am writing an application to backup and restore M.S. Exchange server
programatically. I am using the Exchange Backup and Restore API and am
developing the application in VC++ 6.0 on a Windows Server 2003 Enterprise
Editioon. I am able to do the backup successfully but I am getting error in
the function "HrESERestoreAddDatabase" during the resore. I am trying to call
the function HrESERestoreComplete as follows:
strTempLocationPath = _T("C:\\viraj\\exchangedata_b...Never Ceasing Error Message in My Mailbox
Account: 'cwjamaicA', Server: 'mail.cwjamaica.com', Protocol: POP3, Server
Response: '.', Port: 110, Secure(SSL): No, Error Number: 0x800CCC18
Hello, I keep getting the message as stated above in Email box. What does
this mean and how can I clear this up. Thanks.
...ALL of my email is gone- getting error message as well
I am getting this message:
The message store has been corrupted by an application external to Windows
Mail. Windows Mail has been able to successfully recover from this
In addition ALL of my emails are gone.
Any suggestions on how I can recover them? And what I should do about the
Try running the various repair functions in
the WMUtil program: http://www.oehelp.com/WMUtil
If still no improvement, upgrade to Windows Live Mail:
It will automatically import all your WM data.
Gary VanderMolen, Microsoft MVP (Mai...Errors 0xC00CE553 and 0x800CCC32
If I may request your assistance again:
I keep getting this error message 0x800CCC32 in a random mode and with
diverse reasons, such as "Not Authorized", "Verify user and password", "Bad
password", "Incorrect user or password" etc.
Now I am also getting a 0xC00CE553 error.
This happened usually randomly, in regard to 5 MSN and 3 Legacy Hotmail
accounts I have, when downloading the messages. Most times it does not
occur. Yet and in spite of the error, the messages download anyway.
I have implemented placing msn.com and hotmail.com into the Privacy tab o...Send and Receive All Error Message
When Sending and Receiving before going offline with
Outlook XP,(exchange 2000) I get the following error...
Task 'Microsoft Exchange Server' reported error
(0x8004010F) : 'The operation failed. An object could not
...Outlook 2000 error msg.
I am running XP on a Dell 8200. I've been using Outlook
2000 for a long time now and all of the sudden I get the
following msg: unable to open default e-mail folder.
C:\Documents and Settings\tdiehl\application
I have inserted MO-2000 CD and tried to repair and
removed the program completely from machine and
reinstalled. NO luck. Any ideas???
How big is your pst file?
"Ted D." <firstname.lastname@example.org> wrote in message
> I am running XP on a Dell 8200. I've been using Outlook...Can not install Office Ultimate 2007 because of a setup error mess
I have a desktop with no Office Suite which I built with Windows XP Pro SP2
(Version 2002), from a WGA Kit. I ordered the back-up discs (2 pcs) Office
Ultimate 2007 from digital river.com store and tried installing in this
machine but I get this message: "Setup error: The language of this
installation package is not supported by your system." I tried it on the 2nd
DVD drive of the same machine but same result. I tried installing the Office
software in a Sony Vaio laptop and it seems it will install properly and I
discontinued the setup. Any information/ass...Pivot table fields missing on all computers
I have Excel 2007 installed on two computers. I also have Excel 2010
beta installed on one of the computers.
I am unable to create a pivot table on ANY of them. None will show the
field list. All copies of Excel work fine in all other aspects.
I have searched the net for solutions and found many others have the
same problem but few suggestions to fix it. Many questions never got
any response at all. I did find a reference to try removing the .xlb
file from the XLStart folder. I did, with no results.
I have done all the proper show/hide clicks. I even tried using the
...Outlook 2003 hyperlinking error
Have just installed Outlook 2003, when I click on a html
link within an email it opens my default web browser
however the link appears in the browser with these
additional symbols which stop the requested site from
Does anyone know how to fix this problem? Its driving me
...Excel color palette missing colors
Opening a workbook with text formatted in color (orange) defaults to gray.
Examination of the color palette shows that that shade of orange is missing
from the palette itself.
Exiting Excel and restarting it sometimes solves the problem. Text rendered
in orange is orange again and the color swatch is back in the palette. User
has tried rebooting the system too.
...reported error (0x80070057)
When I try to send an email to several addresses using Outlook 2003, I get
Task 'xxx - Sending' reported error (0x80070057) : 'Could not complete the
operation. One or more parameter values are not valid.'
I see no apparent problem with the addresses. Please tell me in simple
English (well, as simple as possible) how to solve this problem. I am not an
What type of mail account is this? Exchange, POP3, IMAP?
"lemonscented" <email@example.com> wrote in message
news:EC994AB1-B72B-4...Createing Quote sometimes make Error: 80070057
Today I found some funny problems.
I create Quotes via the quote WebService from the CRM.
This normally works fine, but now I have some quotes, which will get me an
error, when I open it. This error is no normal error, I will get an
white/yellow Page with ASPX Errorpage:
Here the Message (sorry but I only have this error in German):
Serverfehler in der Anwendung '/'.
Beschreibung: Beim Ausf�hren der aktuellen Webanforderung ist ein
unverarbeiteter Fehler aufgetret...Consecutive Query
For your consideration I have the following question.
I have a process that leads to the below dataset.
Name Start Date End Date
Chris 11/2/2008 11/9/2009
Joe 11/1/2008 11/8/2008
Joe 11/8/2008 11/22/2008
Joe 11/22/2008 11/29/2008
Joe 12/10/2008 12/17/2008
Joe 12/17/2008 12/24/2008
Now that I have this dataset I would like to only include Arrival
Dates that begin on a day within a 6 day range. ...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...List box with available queries question
I have a list box control on a form and want the list box to display all the
queries within the database. The following code is what I have so far but it
does not work. Any help is appreciated.
SELECT [Name] FROM MSysObjects WHERE [TYPE] = 5 and LEFT([Name],1) <> "-"
ORDER BY [Name];
"Billy B" <BillyB@discussions.microsoft.com> wrote in message
>I have a list box control on a form and want the list box to display all
> queries within the database. The following code is what...Compile Error in hidden module: Autoexec #2
I need help when ever I opepen or close any office
product ( excel , word etc...) I get the message shown
above.... How do I fix it please help
Take a look at this:
"Ash" <firstname.lastname@example.org> skrev i meddelandet
> I need help when ever I opepen or close any office
> product ( excel , word etc...) I get the message shown
> above.... How do I fix it please help
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...Help with queries
This is the first time after school that I am trying to use ms access at
work and i need ur help in creating a query.
Any help will be highly appreciated!!
Here is what I need...
I have relatively small ms acces database with about 1000
I have 3 colums
date ipaddress sitename
12/09 22.214.171.124 A
12/09 126.96.36.199 A
12/09 188.8.131.52 A
12/09 184.108.40.206 B
12/09 220.127.116.11 C
What i need is if an ipadress is recorded more t...missing entries
I sometimes make an entry to the address book, save it, and then search for
it only to find that it is not there. When I re-enter the entry and save it
I get the message that it is already a part of the address book and pulls up
the entry asking me if I want to update that record. I do just that, but
when I try to access the record again it does not find it.
You never use the address book view to create entries. It contains no data.
Use your Contacts Folder.
"Missing Outlook Entries" <Missing Outlook
Entries@discussions.microsoft.com> wr...Run-time error '380'
Back in 2003 I created a macro for a form that was working fine. I haven't
used it since but now that I need it, I get all these strange errors that I
am sure where not there back in 2003 (e.g. I had to in include VBA in the
txtBirth.Value = VBA.Format(spnBirth.Value, "d-mmm-yyyy")
Now my problem is with the code:
spnDOE.Value = Date
when I get a run-time error 380 that it could not set the value property.
Invalid property value.
...windows xp system error with kernel32.dll (crash)
AppName: iexplore.exe AppVer: 7.0.6000.16608 ModName: kernel32.dll
ModVer: 5.1.2600.3119 Offset: 00012a5b
The group you posted to is for Microsoft Access (the desktop database.)
You might do better to post to an Internet Explorer group, or a Windows
(Sorry to do that to you when this kernel issue is probably driving you
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"jackzhao" <email@example.com> wrote in messag...divide by 0 error jmp
I have a spreadsheet where if certain cells are empty, I get a divide by 0
errors. I understand I can nopt divide by 0; that is not the issue. My issue
is I can not seem to add a column of numbers if one or more have divide by 0
Can someone suggest how I can either get rid of the divide/0 error, or be
able to add a selection of cells where 1 or more have /0 errors?
Hi the choice is your:-
To sume a range with div/0 in use
To eliminate div/o use
In this case 9/c6 generates a Div/0 error
&qu...Outlook Express Problems #5
I am creating an address Group in Express. I added about
75 addresses, and ... suddenly I see ONLY 50!! Where did
the other 25 go to? What can I do to solve this?
I would like to enter a large number of email addresses in
BCC. Is there a way to conveniently do this? In AOL you
can apparently enter a bunch of addresses into CC:, with
parentheses at start and finish. Can you do this in
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the...