Search the web
Sign In
New User? Sign Up
textpipe-discuss · TextPipe user discussion forum
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Extracting two lines together... ? Help! :)   Message List  
Reply | Forward Message #518 of 525 |
I have been working on some data extraction. I am using textpipe
pro as well as Easy pattern helper.. I need to extract two lines
that read like this
Sales:
$200.12 bil
There is the line break in it and the numbers in red are the
variable chars.
I can get it to pull up using the Perl pattern
(?:Sales:)
(?:(?:[[:digit:]!"#$%&'()*+,\-./\\:;=?@\[\]\^_`{}~|]{1,7}?))(?:
bil) ........ which is the same as this EasyPattern

Sales:
[ longest 1 to 7 digits or <!"#$%&'()*+,-./\:;=?@[]^_`{}~|> ] bil

But what it's doing is pulling two separate lines so I get Sales:
and the number that goes with it.. plus a million other numbers that
match that "number" pattern on these documents.. The entire reason
I'm using the word Sales: is that it's the only way to distinguish
that number from all the rest of them!! I've tried everything I can
think of in between there like [newline] [linefeed] [return] .. (of
course their Perl conversions) .. but nothing works!!
Can someone please help me find a way to extract those two lines
together? Can that be done?
I have been working on this forever now and I have a major deadline
on this.. Please Help!!! :)
Thanks,
Tori









Thu Jul 27, 2006 7:46 pm

sevenkitty_77
Offline Offline
Send Email Send Email

Forward
Message #518 of 525 |
Expand Messages Author Sort by Date

I have been working on some data extraction. I am using textpipe pro as well as Easy pattern helper.. I need to extract two lines that read like this Sales: ...
Seven
sevenkitty_77
Offline Send Email
Jul 27, 2006
10:10 pm

... Simple. Replace line break with whitespace after "Sales:" First filter (replace): -Search (Sales:)(\r\n) -Replace with $1[ ] Second filter (extract...
d.rybas
Offline Send Email
Feb 7, 2007
9:15 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help