Loading ...
Sorry, an error occurred while loading the content.

Re: [Clip] Re: reg exp & clip solution

Expand Messages
  • Larry Thomas
    Hi Ben, ... This is the number one reason that I keep reading and participating in this list. Every once in a while someone comes up with something there that
    Message 1 of 1 , Nov 1, 2003
    • 0 Attachment
      Hi Ben,

      At 02:11 PM 11/1/03 -0800, you wrote:
      >On Friday, Oct 31, 2003
      >BHCS wrote regarding "reg exp & clip solution";
      >
      >Hi Bill,
      >
      >Something like this may do what you want;
      >
      >H="Extract client data"
      >^!Set %client%=^?[Enter client name]
      >^!Set %tempfile%=^$GetTempFile$
      >^!Jump Doc_Start
      >:repeat
      >^!Find "".*",".*","^%client%",".*",".*",".*",".*",".*"" RS
      >^!IfError finish
      >^!AppendToFile "^%tempfile%" ^$GetSelection$^%NL%
      >^!GoTo repeat
      >:finish
      >^!Open ^%tempfile%
      >^!SetWizardLabel "Save to R:\Clients\BillableHrs\"
      >^!RenameDoc ^?{As:=^%client%.txt}
      >^!Save As "R:\Clients\BillableHrs\^$GetFileName(^**)$"
      >

      This is the number one reason that I keep reading and participating in this
      list. Every once in a while someone comes up with something there that I
      did not even know about that was right under my nose and I just did not see
      it. In this case it was the ^$GetTempFile$ function. When I first read
      your coding and I saw it, I wondered where in the world did you get that
      from!!!? Then I looked it up in help and ran an infobox using it. Wonderful.

      Thank you very much Ben. Please do it more often if you can !-)


      Regards,

      Larry
      lrt@... e¿ê
    Your message has been successfully submitted and would be delivered to recipients shortly.