Jump to content
Macro Express Forums

Parse Selected Lines From Clipboard


veadtuck
 Share

Recommended Posts

i'm really new into ME. i think my question is really simple to answer. i have following content in my clipboard:

 

333333333   Suspended   testdummy1   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222   
333333333   Suspended   testdummy2   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222
333333333   Active   testdummy3   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222   
333333333   Active   testdummy4   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222   
333333333   Suspended   testdummy5   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222   
333333333   Suspended   testdummy6   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222   
333333333   Active   testdummy7   Jan-01-01 11:11:11 PDT    Coffe Cup   11111111-22222222222  

 

now i want to parse this, that following will be left:

 

Suspended   testdummy1    Coffe Cup   11111111-22222222222   
Suspended   testdummy2    Coffe Cup   11111111-22222222222   
Suspended   testdummy5    Coffe Cup   11111111-22222222222   
Suspended   testdummy6    Coffe Cup   11111111-22222222222  

 

sorry, but i don't get it to parse single-lines from the clipboard, only from textfiles - but i don't want to save the content as a textfiles first, to get it parsed. :huh:

Link to comment
Share on other sites

I would copy it to a text variable and use variable manipulations to chew thru it. This post has a good example of this. If that isn't enough to get you started ask again with more detailed questions. It looks like some of your stuff is a uniform number count so you can just extract X numbers of characters instead of searching for text.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...