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

RE: [BATCH WORLD] Input in CSV file

Expand Messages
  • Derek Byrne
    not sure how you created your csv file, but you can use the %date% and %time% variables that are available on the command line (tested on win2k). db ... From:
    Message 1 of 3 , Apr 11, 2005
    • 0 Attachment
      not sure how you created your csv file, but you can use the %date% and
      %time% variables that are available on the command line (tested on win2k).

      db

      -----Original Message-----
      From: beatconnect [mailto:beatconnect@...]
      Sent: 10 April 2005 22:21
      To: batchworld@yahoogroups.com
      Subject: [BATCH WORLD] Input in CSV file





      My original csv file is 192.169.0.1;729;00447865499974;0017039808543.
      How can I add date and time either in the beginning of each line or at
      the end of line ie 20050409;11.20;with the help of batch file. Any
      Help?.








      To Post a message, send it to: batchworld@...

      To Unsubscribe, send a blank message to: batchworld-unsubscribe@...
      Yahoo! Groups Links







      **********************************************************************
      Meteor web site http://www.meteor.ie
      **********************************************************************
    • Beat Connect
      Hi Mic It is for Win 2k. I need both fixed date in some cases and sysdate in some cases. Thanks beatconnect Mic wrote: ... Which OS is it
      Message 2 of 3 , Apr 11, 2005
      • 0 Attachment
        Hi Mic

        It is for Win 2k. I need both fixed date in some cases and sysdate in some cases. Thanks

        beatconnect

        Mic <micm@...> wrote:
        On Sun, 10 Apr 2005 21:20:39 -0000, beatconnect wrote:

        > My original csv file is 192.169.0.1;729;00447865499974;0017039808543.
        > How can I add date and time either in the beginning of each line or at
        > the end of line ie 20050409;11.20;with the help of batch file. Any
        > Help?.

        Which OS is it for?

        Do you want the current date and time, or a fixed date and time?


        --
        Regards,
        Mic


        To Post a message, send it to: batchworld@...

        To Unsubscribe, send a blank message to: batchworld-unsubscribe@...



        ---------------------------------
        Yahoo! Groups Links

        To visit your group on the web, go to:
        http://groups.yahoo.com/group/batchworld/

        To unsubscribe from this group, send an email to:
        batchworld-unsubscribe@yahoogroups.com

        Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



        ---------------------------------
        Do you Yahoo!?
        Yahoo! Small Business - Try our new resources site!

        [Non-text portions of this message have been removed]
      • Mic
        ... Lo beat ... I can t help but get the feeling it s an assignment. Assemble these commands in the correct order... set newdate=%date% set
        Message 3 of 3 , Apr 12, 2005
        • 0 Attachment
          On Mon, 11 Apr 2005 11:25:45 -0700 (PDT), Beat Connect wrote:

          > Hi Mic

          Lo beat

          > It is for Win 2k. I need both fixed date in some cases and sysdate in
          > some cases. Thanks

          I can't help but get the feeling it's an assignment.

          Assemble these commands in the correct order...


          set newdate=%date%
          set newdate=%newdate:-=%
          echo %newdate%

          set newtime=%time%
          echo %newtime%

          @echo off
          for /f "delims=" %%a in (file.csv) do (
          >>newfile.csv echo %newdate%;%newtime%;%%a
          )





          > Mic <micm@...> wrote:
          > On Sun, 10 Apr 2005 21:20:39 -0000, beatconnect wrote:
          >
          >> My original csv file is 192.169.0.1;729;00447865499974;0017039808543.
          >> How can I add date and time either in the beginning of each line or at
          >> the end of line ie 20050409;11.20;with the help of batch file. Any
          >> Help?.
          >
          > Which OS is it for?
          >
          > Do you want the current date and time, or a fixed date and time?


          --
          Regards,
          Mic
        Your message has been successfully submitted and would be delivered to recipients shortly.