none
batch script to convert .*txt to .*txt column separated

    Question

  • Hello,
    I'm new with batch scripting, although I know bit from VB script. Therefore I think my question is problably not very difficult. I  hope someone can help me out.

    I have got a .txt file that I want to import therefore the txt file needs to be separated.

    The Original txt file displays the values in 1 row. The values are sepated by ;

    When I open the file in Excel it automatically separates the values in 11 columns and multiple rows,
    For my import I need te values to be in multiple rows.

    I do not want to open the original file in excel. Save it etc. I want this action scripted if possible.

    Can you help me? :)

    Wednesday, January 11, 2017 4:14 PM

Answers