Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Exporting / Importing File names from https to Excel / Word  (Read 11894 times)

0 Members and 1 Guest are viewing this topic.

jaidev.anand

    Topic Starter


    Rookie

    • Experience: Familiar
    • OS: Windows 7
    Re: Exporting / Importing File names from https to Excel / Word
    « Reply #30 on: November 16, 2012, 07:49:46 AM »
    So you take you bat and ball and go home rather than work *with* the people that are solving your problem - for free.

    Sir, I think I said I'm sorry and immensely thankful:)

    foxidrive



      Specialist
    • Thanked: 268
    • Experience: Experienced
    • OS: Windows 8
    Re: Exporting / Importing File names from https to Excel / Word
    « Reply #31 on: November 16, 2012, 07:54:53 AM »
    This will only work if all the files are .wav files.

    EDITED: to add a delims section


    Code: [Select]
    @echo off
    del "output file.txt" 2>nul
    for /f "delims=" %%a in (listofserialnumbers.txt) do (
    for /f "delims=." %%b in ('find "-%%a-" ^< "list of files.txt"') do (
    >>"output file.txt" echo %%b.wav
    )
    )

    jaidev.anand

      Topic Starter


      Rookie

      • Experience: Familiar
      • OS: Windows 7
      Re: Exporting / Importing File names from https to Excel / Word
      « Reply #32 on: November 16, 2012, 08:00:07 AM »
      This will only work if all the files are .wav files.

      EDITED: to add a delims section


      Code: [Select]
      @echo off
      del "output file.txt" 2>nul
      for /f "delims=" %%a in (listofserialnumbers.txt) do (
      for /f "delims=." %%b in ('find "-%%a-" ^< "list of files.txt"') do (
      >>"output file.txt" echo %%b.wav
      )
      )

      It definately did. Thanks again!