Computing.Net > Forums > Office Software > Solve my sequence number problem...

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Solve my sequence number problem...

Reply to Message Icon

Name: Andy Vertin
Date: October 31, 2005 at 12:40:15 Pacific
OS: Windows XP
CPU/Ram: Plenty
Comment:

I have a file with about 2000 lines of the following:

10/30/05 06:38:36 00000SIRQ
10/30/05 06:38:36 00000SIR0
10/30/05 06:39:57 00000SIRQ
10/30/05 06:39:57 00000SIR0

I need to assign sequence numbers to each pair like this:

10/30/05 06:38:36 00001SIRQ
10/30/05 06:38:36 00001SIR0
10/30/05 06:39:57 00002SIRQ
10/30/05 06:39:57 00002SIR0
10/30/05 06:40:11 00003SIRQ
10/30/05 06:40:11 00003SIR0

Any way to automate this "find and replace" process, maybe with Excel or something?



Sponsored Link
Ads by Google

Response Number 1
Name: Grok Lobster
Date: October 31, 2005 at 14:44:18 Pacific
Reply:

In another column next to this data, enter 1, 1, 2, 2, 3, 3 and then select these cells and drag down to auto enter the remainder. Now, in the next column enter = left(A1, 22) & B1 & right(A1, 4). Drag to autofill the remainder of the column.


0

Response Number 2
Name: wizard-fred
Date: November 1, 2005 at 06:37:16 Pacific
Reply:

The previous method would work with the following small problem the length of the string should adjusted as the number grows. Also make sure that column b is a string.

I would prefer a small program that verifies the S1RQ, S1R0 pair has the same date and time.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Solve my sequence number problem...

Word XP numbering problem (inconsis www.computing.net/answers/office/word-xp-numbering-problem-inconsis/1606.html

Conditional Formatting-Formula www.computing.net/answers/office/conditional-formattingformula/9513.html

Rolodex sharing problem www.computing.net/answers/office/rolodex-sharing-problem/3764.html