DosTips.com

Code: Select all

@echo off & cls & SetLocal EnableExtensions EnableDelayedExpansion

:enter_dir
  set /p "dir_source=[c:\dir1\dir2...] enter dir with source file's="
  if NOT defined dir_source goto enter_dir

if "%dir_source:~-1%" == "\" set "dir_source=%dir_source:~0,-1%"
if NOT exist "%dir_source%\*.txt" (
  echo:*.txt file's not found in '%dir_source%\'
  pause & exit /b 1
)
if NOT exist "%dir_source%\results" md "%dir_source%\results"||(
  echo:can't make dir '%dir_source%\results'
  pause & exit /b 2
)

for /f "tokens=*" %%v in ('dir /b ".\%dir_source%\*.txt"') do (set "line_source="
    <"%dir_source%\%%v" >"%dir_source%\results\%%v" (for /f "tokens=*" %%L in ('find /n /v ""') do (set "line=%%L" & set "line=!line:*]=!"
      if "!line!" == "" (
        echo:!line!
      ) else (
        if "!line:~0,2!" == "2|" (
          set "line_source=!line!"
        ) else (
          if "!line:~0,2!" == "3|" set "line=!line!!line_source!"
          echo:!line!
        )
      )
    )
  )
)
echo:see results in dir '%dir_source%\results'
pause
exit /b 0

Code: Select all

1|123|
3|CDR|XYZ|||||||||||||2|Source|T|2016-01-01
3|CDR|XYZ|||||||||||||2|Source|T|2016-01-01
4|||||||

3|CDR1|XYZ1|||||||||||||2|Source|T1|2016-02-01
3|CDR2|XYZ2|||||||||||||2|Source|T1|2016-02-01
3|CDR1|abc1|||||||||||||2|Source|T1|2016-02-01
3|CDR2|abc2|||||||||||||2|Source|T1|2016-02-01
4|||||||
3|CDR3|XYZ3|||||||||||||2|Source|T2|2016-03-01
3|CDR4|XYZ4|||||||||||||2|Source|T2|2016-03-01
4|||||||
5||||||||