How can I convert a .csv file to a space delimited .txt file in one step

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • brat33
    New Member
    • Jan 2010
    • 36

    How can I convert a .csv file to a space delimited .txt file in one step

    I am trying to rename, convert, and move a file in one step.
    I have file one:
    \\server\folder \folder\file.cs v
    that I need to convert into space delimited file and rename it and move to another location all in one step.

    Does anyone have any suggestions? I can move the file fine using Command Scripting using:
    copy \\server\folder \folder\file.cs v \\server2\folde r\folder\file.t xt /Y
    BUT the .txt file is still in comma delimited format. I am missing the important "conversion " step in here.

    Can anyone help me to get this file converted, moved, and of course renamed at the same time?

    Thanks in advance!
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    It's is windows I guess? If co can you install some additional tools like sed for windows? With it the task should be quite easy.

    Comment

    • brat33
      New Member
      • Jan 2010
      • 36

      #3
      Thank you for the information. I went with a .VBS script to perform the conversion. I will have to look into sed as I have never heard of this before. Thanks again!

      Comment

      Working...