I'm trying to CAPTURE specfic strings from a text file and place them in an excel workbook. I NEED the payment and the chk number side by side so payment in column A and chk num that corresponds to the payment in column B if possbile if not a txt file will be ok. The code i m using now which is below just puts them in a new text file and its not excactly how i want to the file to output. This is what i need from the file.

1. payment total and the amount anything after in that line is not needed
2. CHECK/EFT NUMBER and chk noanything after in that line is not needed

ex.
payment total 21115.36
CHECK/EFT NUMBER: 0000011111111
Code: [Select]
find /i "CHECK/EFT NUMBER" "C:\test\New Folder\*.txt" >> "C:\test\New Folder\log.txt"

find /i "PAYMENT TOTAL:" "C:\test\New Folder\*.txt" >> "C:\test\New Folder\log.txt"




[recovering disk space, attachment deleted by admin]Code: [Select]@echo off

FOR /F "tokens=1-3 delims= " %%G in ('type pcplus.txt ^|findstr /C:"PAYMENT TOTAL:" /C:"CHECK/EFT NUMBER:"') DO (
IF "%%G"=="PAYMENT" >>log.txt set/p"=%%G %%H %%I "<nul
IF "%%G"=="CHECK/EFT" >>log.txt echo %%G %%H %%I
)
Output from the file you supplied.
Code: [Select]PAYMENT TOTAL: 21115.36 CHECK/EFT NUMBER: 0000011111111
PAYMENT TOTAL: 11189.01 CHECK/EFT NUMBER: 0000011111111
PAYMENT TOTAL: 16.18 CHECK/EFT NUMBER: 0000011111111
PAYMENT TOTAL: 1188.00 CHECK/EFT NUMBER: 0000011111111
PAYMENT TOTAL: 12130.17 CHECK/EFT NUMBER: 0000011111111
PAYMENT TOTAL: 2102.22 CHECK/EFT NUMBER: 0000011111111
great! thanks squashman. if possible can you explain what is occuring on these two lines after the >>log.txt for example whats removing the the data after the payment amount and how doesthe script know where the payment amount ends and to remove anything after it? also if possbile can the file be output like so...

Code: [Select]PAYMENT TOTAL: CHECK/EFT NUMBER:
21115.36 0000011111111
11189.01 0000011111111
16.18 0000011111111
1188.00 0000011111111
12130.17 0000011111111
2102.22 0000011111111


I Have the bottom portion using the below code im just trying to get the first row to show as above

Code: [Select]FOR /F "tokens=1-3 delims= " %%G in ('type pcplus.txt ^|findstr /C:"PAYMENT TOTAL:" /C:"CHECK/EFT NUMBER:"') DO (

IF "%%G"=="PAYMENT" >>log.txt set/p"=%%I "<nul
IF "%%G"=="CHECK/EFT" >>log.txt echo %%I

)



If you know that is what you want as the first line of your output file then hard code it before the for loop. K.I.S.S.thank again for the tip . Sorry but i realize im going to need a few more things from the file.
i'm trying to see how i can also capture
PAYMENT DATE:
RUN DATE:
also need the the ones i listed below but im note sure how i can go about capturing them since the names are always changing. But there always in the same position in the file
EMPIR
PAYERS CC
and also need CC separately. CC


Code: [Select]@echo off
Echo PAYMENT TOTAL: CHECK/EFT NUMBER: PAYMENT DATE: RUN DATE: PAYERS: PAYER: >>log.txt
FOR /F "tokens=1-3 delims= " %%G in ('type pcplus.txt ^|findstr /C:"PAYMENT DATE:" /C:"RUN DATE:" /C:"PAYMENT TOTAL:" /C:"CHECK/EFT NUMBER:"') DO (

IF "%%G"=="PAYMENT" >>log.txt set/p"=%%G %%H %%I "<nul
IF "%%G"=="CHECK/EFT" >>log.txt echo %%G %%H %%I

REM I tried the below but it does not work
IF "%%G"=="PAYMENT DATE:" >>log.txt echo %%G %%H %%I
IF "%%G"=="RUN DATE:" >>log.txt echo %%G %%H %%I
)
Quote from: daillest319 on June 25, 2013, 11:11:12 PM

thank again for the tip . Sorry but i realize im going to need a few more things from the file.

this works perfect foxidrive thank you so much. btw If you have any free time i would like to understand what occuring in the script if you can write notes to what each line is doing i would really appericate it im just curious how it know where to grab certain string for example the string in the GPO line. thank you all again i really do appericate all the help i recieve in this forum.