Search results for query: *

Thank You PHV. That worked great. Now I have another problem. Does it allow for an "OR" correlation? I was removing another line that started to the far left using this: strcomp(left(strCurrentLine,1)," ") = 0 Is there a way that could be added to this? If Len(strCurrentLine) > 45 And...

I can't understand why this doesn't work and I was hoping someone can help me. I want to exclude certain lines from a text file based on conditions. This is giving me a result when I print out the msgbox but the file I'm writing to is coming up empty. Basically I want to keep everything where...

Skip, Is there any chance you can forward a spreadsheet example to jamesvolkman@yahoo.com ? I understand the corresponding sequence values but it's hard to follow everything. I appreciate your help as I could have never considered this approach.

I was hoping someone might be able to help with a formula I'm attempting. We classify different time segments throughout the day as prime hours and I need to total those hours. The biggest problem is that the prime hours for Saturday are different than the prime hours of Monday through Friday. I...

We use a terminal mainframe that stores an internal date. The internal date is the number of days since December 31st, 1967. I've tried reaching that number (i.e. 14,708) but I can't seem to get it work. This will give me an out of range error. Is there a float version of "intsltime"? I...

Huntersdad, Upon further thought you were actually correct. I just needed to assign the month and decrement the year once we reached December. Integer TotalMonths = 11 For Loops = 1 upto TotalMonths iDay = 1 iMonth-- if iMonth == 0 iDay = 1 iMonth = 12 iYear-- endif

I decided to cut my losses. I don't know Aspect well enough to be doing file manipulations.

We use a terminal mainframe that stores an internal date. The internal date is the number of days since December 31st, 1967. I've tried reaching that number (i.e. 14,708) but I can't seem to get it work. This will give me an out of range error. Is there a float version of "intsltime"? I...

Thank You for your replies. I'm not sure decrementing by just the month will work. You also need to rollback by year. This gave me the first day of the month for the previous two months. for Loops = 0 upto 1 ******GO BACK ONE MONTH************ lCurTime = $LTIME ltimeints lCurTime iYear iMonth...

I don't have a good understanding of file manipulation using aspect and I was hoping someone could help. I'm determining the length of each line in a text file. If the length is longer than 12 characters, I want to insert several spaces at the start of the line. I basically want to push the data...

I stoled some of this from other scripts on this site. This starts off giving me the first and last day of the month for the previous month. I was wondering if anyone knows how I loop this so it would decrement the month each time through. January -08 December - 07 November - 07 etc... proc...

I think you're right. Thanks.

I'm attempting to login to another computer remotely. Everything is working up to the Windows Login which is titled "Log On To Windows". The Windows Login Window is inside of the Remote Connection window and I can't make it the focus. #Include "VKEYS.INC" proc main string sRemote integer...

Nevermind. I guess I don't need to increment when using a for loop.

I have a process that employs rget to grab a number off the screen, place that number into an integer, and loops that many number of times. The problem I'm having is that Counter is incrementing twice for each loop as opposed to one time. I tried Counter = Counter + 1 and got the same result...

GlennUK, That worked great. Thanks again and I appreciate everyone's input. You're showing me things I never knew Excel could do.

I think this is on the right track. =IF(COUNTIF($A$2:$A$1305,A2)=1,D2-C2,IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$10676,A2),D2-C2,""))

That's not really working. There are other columns in the report so I need the time to match against column A listed above. Also, the time is actually a recording of an action and we can have actions happening on the account beginning and ending at the same exact time and it only seems to be...

GlenUK, I was wondering if there's anyway to alter this array to give the total time between each start and end times. This is for a call report. This formula is currently providing the difference between the minimum start time and maximum end time on the account. Based on the times below that...

I'll give that a try. I decided to scrap the report for now due to a different reason. It appears that DDE starts to fail when you exceed a certain amount of columns and/or records in Excel. I added a few columns to the report and the data became sporadic as though it couldn't hold enough...