LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Find, select, cut and paste

Hello

I am completely new to excel programming and I would like some help if
possible.
I have a spreadsheet with some logging information. I am trying to get
the text split when I found the string "Initializing server", which
can happens many times.
So basically, I need to create new sheets every time I found this
string, copying all the content found until it reaches the row with
that string to the new sheet.
Here is a piece of the log file:

| 2008-06-16 13:34:22.916 | 71212 | ArsInit | 101 | Initializing
server | 3
| 2008-06-16 13:34:22.948 | 71212 | ReqLoop | 201 | Entering Request
1 | 1
| 2008-06-16 13:34:22.948 | 71212 | ReqLoop | 227 | Received
Scriptname: /scripts/adess.dll | 1
| 2008-06-16 13:34:22.948 | 71212 | ReqLoop | 213 | Reading GET
request | 1
| 2008-06-16 13:35:01.462 | 71212 | ArsInit | 101 | Initializing
server | 3
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 231 | Creating request
| 1
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 219 | Created request
| 1
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 235 | Request: service
= GetPollingDelay | 1
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 235 | Request:
connectionKey = | 1

On this case, the result should be two sheets, one with this info

| 2008-06-16 13:34:22.948 | 71212 | ReqLoop | 201 | Entering Request
1 | 1
| 2008-06-16 13:34:22.948 | 71212 | ReqLoop | 227 | Received
Scriptname: /scripts/adess.dll | 1
| 2008-06-16 13:34:22.948 | 71212 | ReqLoop | 213 | Reading GET
request | 1

and another one with this

| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 231 | Creating request
| 1
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 219 | Created request
| 1
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 235 | Request: service
= GetPollingDelay | 1
| 2008-06-16 13:35:01.477 | 71212 | ReqLoop | 235 | Request:
connectionKey = | 1

Is is possible to help me?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select, find in another book, copy, return and paste Watson[_2_] Excel Discussion (Misc queries) 0 August 15th 08 07:14 PM
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. tln Links and Linking in Excel 0 April 22nd 07 04:28 PM
Find/Copy/paste.. then Find/Paste - not working ... at all.... [email protected] Excel Programming 9 November 30th 06 08:49 PM
help with find value select range and paste to diff sheet, multipl MFR Excel Programming 1 October 29th 06 08:51 PM
I need to find a macro to find data cut and paste to another colu. Rex Excel Programming 6 December 7th 04 09:22 AM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"