Loading ...
Sorry, an error occurred while loading the content.
Advanced Search
Author
Subject
Message
Special notice only

Advanced Search
  • Thanks John, Cheers, Robin At 21/01/2015 08:32 AM, you wrote: This removes all leading spaces. ^!Replace "^\x20+" >> "" ARSW To remove all trailing spaces: ^!Replace "\x20+$" >> "" ARSW Regards, John RecipeTools Web Site: http://recipetools.gotdns.com/recipetools/ RecipeTools Yahoo Group: http://groups.yahoo.com/group/RecipeTools/ John's Mags Yahoo Group: http://groups.yahoo.com...
    Robin Chapple Jan 20, 2015
  • Greetings, For a few years I have been using this clip to remove the leading space that appears in too much email text that I need to use for other purposes. ^!Jump DOC_START ;FIND Leading Space AND REPLACE ^!Replace "^P " >> "^P" WAIS It has worked well but does not remove a leading space in the first paragraph. Is it possible to do that? Many thanks, Robin Chapple
    Robin Chapple Jan 20, 2015
  • Axel and Don, Many thanks for your help. Robin At 18/09/2014 01:05 AM, you wrote: ^.*\<([^ ]?@^$1*?)\>.*$ It all depends on the data :-) You could also do a find for: >.*> and <.*< to find any lines with two such marks and only proceed if not found. Good stuff to think about. On the other hand, load it in excel, do text to columns and use the < and the > to define the columns...
    Robin Chapple Sep 19, 2014
  • Fetching Sponsored Content...
  • I need to extract email addresses from a list in this format: "FirstName" "LastName" The text before the "<" varies and also after the ">". So I need a script that removes up to and including < and what ever follows > That would be greatly appreciated. Many thanks, Robin Chapple
    Robin Chapple Sep 17, 2014
  • At 29/06/2014 01:20 AM, you wrote: >"Robin Chapple robinski@^$1 [ntb-clips]" wrote: > > In this case the email field is extracted to add to a mailing list. > > No other fields are impacted...
    Robin Chapple Jun 28, 2014
  • Thanks for the thought Axel. In this case the email field is extracted to add to a mailing list. No other fields are impacted. Cheers, Robin. At 27/06/2014 11:36 AM, you wrote: "Alec Burgess buralex@^$1 [ntb-clips]" wrote: > (not tested) > ^!replace "[ \.]+$" >> "" rwsai In principle that's what I'd have said, but it makes assuptions about the format used. It would be better to...
    Robin Chapple Jun 27, 2014
  • Thanks Alec, That worked a treat! Regards, Robin At 27/06/2014 10:56 AM, you wrote: On 2014-06-26 20:42, Robin Chapple robinski@^$1 [ntb-clips] wrote: > I have a need to 'clean' my club membership list which includes a > field for email address. > > Over...
    Robin Chapple Jun 27, 2014
  • I have a need to 'clean' my club membership list which includes a field for email address. Over the years various persons have included a trailing space or a trailing 'stop' (.) to an address. My new mailing list software will not accept the non conforming addresses. How do I remove trailing spaces and trailing stops? Many thanks, Robin Chapple
    Robin Chapple Jun 26, 2014
  • Thanks John, I will keep the clip and compare next time. Cheers, Robin At 14/02/2014 09:30 AM, you wrote: Slightly smaller and fasterÂ… ^!Replace "^\d+-\d+\K\x20+" >> "\t" ARWS Regards, John RecipeTools Web Site: http://recipetools.gotdns.com/ John's Mags Yahoo Group: http://groups.yahoo.com/group/johnsmags/ From: ntb-clips@^$1 [ mailto:ntb-clips@^$2 ] On Behalf Of Don Sent...
    Robin Chapple Feb 13, 2014
  • Many thanks Don, That gave the required result. I do need the name and clubn separated but that is alraey covered and I do not need yje combined clip. Agaion many thanks, Robin At 14/02/2014 09:25 AM, you wrote: > > >Give this a whirl: > >^!Replace "^(\d+-\d+) +" >> "$1\t" WRASTI > >I assume that the part between name and club is already as you want it >to be.
    Robin Chapple Feb 13, 2014