@echo off
setlocal enabledelayedexpansion
echo DATE TYPE CUSTOM_NO CARD AMOUNT
for /f "tokens=1,2,* delims==, " %%i in (%1) do (
set str1=%%i
set str2=%%j
set str3=%%k
if !flag! equ 2 (
if "!str3:~-8!"=="ACCEPTED" (
echo !name! !TYPE! !CUSTOM_NO! !CARD! !AMOUNT!
)
set flag=
)
if !flag! equ 1 (
set CARD=!str3!
set flag=2
)
rem MOBILE
if "!str2:~0,6!"=="MOBILE" (
set TYPE=!str1:~-3,3! MOBILE
set CUSTOM_NO=!str2:~-11!
if "!TYPE:~0,3!"=="UNI" set CUSTOM_NO=!str3!
)
rem TELEPHONE
if "!str1:~-17,9!"=="TELEPHONE" (
set TYPE=TELEPHONE
set CUSTOM_NO=!str1:~-7!
)
rem WATER
if "!str1:~-14,5!"=="WATER" (
set TYPE=WATER
set CUSTOM_NO=!str1:~-8!
)
rem ELEC
if "!str1:~-5,4!"=="ELEC" (
set TYPE=ELEC
set CUSTOM_NO=!str2:~-8!
)
rem GAS
if "!str1:~-4,3!"=="GAS" (
set TYPE=GAS
set CUSTOM_NO=!str2:~-10!
)
if "!str2:~-3,1!"=="." (
set name=%%~ni
set AMOUNT=!str2!
set flag=1
)
rem GAS AMOUNT format: "**.*"
if "!str2:~-2,1!"=="." (
set name=%%~ni
set AMOUNT=!str2!
set flag=1
)
) |
|