Re: I stink at regexp... Help.
Hello Januk, Thursday, September 18, 2003, 2:00:09 PM, you wrote: JA> The reason it doesn't have a hope of working at the moment is that JA> you forgot to tell TB to actually match anything. Ie, you forgot JA> the %RegExpBlindMatch="% Text"%- part. Add it somewhere after the JA> %SetPattRegexp and before the % SubPatt macros. Thanks for the help. Dima's worked fine too. -- Leif (TB list moderator and fellow end user). Using The Bat! 2.00 under Windows 2000 5.0 Build 2195 Service Pack 3 on a Pentium 4 2GHz with 512MB http://www.silverstones.com/thebat/TBUDLInfo.html
Re: I stink at regexp... Help.
Hello Dima, Thursday, September 18, 2003, 3:20:01 PM, you wrote: D> %SETPATTREGEXP=".*moderate\s\w+\s(\d+)\n" D> %CLEAR D> login password D> moderate approve %RegExpMatch(%QUOTES) D> This gives out the right approve number. :) Most awesome. Exactly what I needed. Thank you. -- Leif (TB list moderator and fellow end user). Using The Bat! 2.00 under Windows 2000 5.0 Build 2195 Service Pack 3 on a Pentium 4 2GHz with 512MB http://www.silverstones.com/thebat/TBUDLInfo.html
Re: I stink at regexp... Help.
Hey there, Leif Gregory! L> |login (enter your password here) L> |moderate approve 4 L> The important part is the # on the line "moderate approve #". L> Here's what I got so far. Don't laugh! It doesn't L> work, at least it doesn't put the number after the word L> "approve". %SETPATTREGEXP=".*moderate\s\w+\s(\d+)\n" %CLEAR login password moderate approve %RegExpMatch(%QUOTES) This gives out the right approve number. :) See ya! -- ___ ICQ:11024900 2:5030/468.557 http://www.dima.sadakov.com http://www.silverstones.com/thebat/TBUDLInfo.html
Re: I stink at regexp... Help.
Hi Leif, On Thu, 18 Sep 2003 12:58:34 -0600, Leif Gregory wrote > Here's what I got so far. Don't laugh! It doesn't work, at > least it doesn't put the number after the word "approve". > %SETPATTREGEXP="moderat(\w+)\s(\w+)\s(\d+)" > %CLEAR > login password > moderate approve %SUBPATT="3" The expression looks like it should work. If you want to tweak your expression, I would have put an anchor for the beginning of the line, make the number of whitespaces variable and set the ignore case option explicitly. I'm probably going overboard, but that's a matter of personal preference. The reason it doesn't have a hope of working at the moment is that you forgot to tell TB to actually match anything. Ie, you forgot the %RegExpBlindMatch="% Text"%- part. Add it somewhere after the %SetPattRegexp and before the % SubPatt macros. -- Good luck, Januk PS: I'm not using TB for this message, so if the quote delimiter doesn't work, it's not my fault...really! ;-) http://www.silverstones.com/thebat/TBUDLInfo.html
Re: how to do this ?
Hello Brano, > I have small databaze in EXCEL. I want send informations to my > friends... now I want to convert it to this format... I dont know > how to do it IMHO, your post is off-topic for this list. I'll post my reply and then sign off. If you're trying to convert column-wise data to row-wise data, you can do it quite easily in Excel. I'm still using Excel 97, but these instructions will surely work in any subsequent version. Select the column-wise data, press Ctrl-C, move the cursor to a clear area of the worksheet where you want the row-wise data to appear, click on Edit, Paste Special, select the Transpose checkbox, click on OK. The row-wise data will now appear in the worksheet. If you want the row-wise data to consist of the field names and a single value, I believe you'll need to use a macro as I don't know of a simple way to do this. However, what you're trying to do requires only an _extremely_ simple database query. My advice, then, is to export your data to Access, perform your query there, and export to text or Excel. If you want some more help, I suggest you contact me privately. regards, Andy [Using The Bat! 1.62r under Windows 2000 Pro SP4 on a "made from scratch" P4-2.4 GHz/512 MB RAM] http://www.silverstones.com/thebat/TBUDLInfo.html
I stink at regexp... Help.
Hello tbtech, Ok, this is probably pretty simple, but I'm just not sure how to get it right in a reasonable amount of time. From a Lyris Listmanager I run here at work, I receive moderation requests from various lists. It looks like this: ,-- [ ] | The attached message destined for this_list has been received. This | message requires your approval before it will be sent to the list. | --- | | To approve this message, send the following two line message to | [EMAIL PROTECTED] | |login (enter your password here) |moderate approve 4 | | --- | | To reject this message, send the following two line message to | [EMAIL PROTECTED] | |login (enter your password here) |moderate reject 4 `-- The important part is the # on the line "moderate approve #". What I want to do (as I figure I'll be approving more than denying), is to set my folder reply template so that it contains only the two lines: login password moderate approve # Where # is the number in the original message. Then I want a quick template called LDENY that will do the same as above, but put only the following two lines: login password moderate deny # Since the number is the same regardless of the approval or disapproval, I don't need to regexp them differently. i.e. I can use the number from the "moderate approve #" line for both instances. Here's what I got so far. Don't laugh! It doesn't work, at least it doesn't put the number after the word "approve". %SETPATTREGEXP="moderat(\w+)\s(\w+)\s(\d+)" %CLEAR login password moderate approve %SUBPATT="3" Any help would be great! Thanks. Tagline of the day: I went to a general store. They wouldn't let me buy anything specific. -- Leif (TB list moderator and fellow end user). Using The Bat! 2.00 under Windows 2000 5.0 Build 2195 Service Pack 3 on a Pentium 4 2GHz with 512MB http://www.silverstones.com/thebat/TBUDLInfo.html
VCard Data
Hello tbtech, Can anyone tell me if it is possible to extract VCard fields within a macro? I'm looking to create a long signature for some mail purposes and I would prefer to use VCard fields, rather than fixed text. I have RTFM, or at least the Help resource and I've failed to find an answer. -- Regards, Peter HB Using The Bat! v2.00.6 on Windows 2000 5.0 Build 2195 Service Pack 3 http://www.silverstones.com/thebat/TBUDLInfo.html
Re: how to do this ?
Hello Dan, Thursday, September 18, 2003, 11:13:41 AM, you wrote: DG> I assume that your friends don't have Excel on their systems. If DG> they did, I assume you would just attach Excel's .xls file to your DG> e-mail). This moderator's interjection is a note to all readers and not just to the person being replied to, even if their post may have instigated this reply. Please don't feel singled out Dan. Please trim replies to context. Try to cut out as much of the original text as possible in your replies so that your response is targeted to specific items in the message you are replying to. You don't necessarily need four layers of quoted material to respond to the last comment made. A sure fire indicator that insufficient trimming has been done is that the original signature and list footer remain in the quoted text, and/or the PGP signature. We have list archives for the purposes of being able to go back to view the entire thread contents. Thank you. -- Leif (TB list moderator and fellow end user). Using The Bat! 2.00 under Windows 2000 5.0 Build 2195 Service Pack 3 on a Pentium 4 2GHz with 512MB http://www.silverstones.com/thebat/TBUDLInfo.html
Re: how to do this ?
Brano- How about a short VBA program on the Excel end of things? -- -Mark Wieder Using The Bat! v1.63 Beta/7 on Windows 2000 5.0 Build 2195 Service Pack 2 http://www.silverstones.com/thebat/TBUDLInfo.html
Re: how to do this ?
Thu, 18 Sep 2003 11:30:10 [GMT +0200] (5:30 AM EDT here) Brano wrote: > Hi all, > I have small databaze in EXCEL. I want send informations to my > friends. Ok, so I make new message, paste some columns from excel, I assume that your friends don't have Excel on their systems. If they did, I assume you would just attach Excel's .xls file to your e-mail). You could have Excel save your information as an HTML file. E-mail the HTML file to your friends. Your friends can read the .htm file with whatever browsers (Internet Explorer, Netscape, Opera, etc.) they have on their systems. > and it looks like this: > 1 column2 column3column 4column 5 column > now I want to convert it to this format, so he gets something like > this: > Name: 1 column > Surname: 2 column > street: 3column > City: 4column > problem is, I dont know how to do it (it is possible?) > thanks > > http://www.silverstones.com/thebat/TBUDLInfo.html Using The Bat! v1.62r on Windows 2000 5.0 Build 2195Service Pack 4 -- Daniel A. Grunberg Kensington, Maryland, USA homepage: www.nyx.net/~dgrunber/ http://www.silverstones.com/thebat/TBUDLInfo.html
how to do this ?
Hi all, I have small databaze in EXCEL. I want send informations to my friends. Ok, so I make new message, paste some columns from excel, and it looks like this: 1 column2 column3column 4column 5 column now I want to convert it to this format, so he gets something like this: Name: 1 column Surname: 2 column street: 3column City: 4column problem is, I dont know how to do it (it is possible?) thanks http://www.silverstones.com/thebat/TBUDLInfo.html
