China DOS Union

Hello everyone, I help manage a forum I set up for a friend.
This forum uses a CGI program, so the forum's data is all in text files.
But some problems came up while editing the text files, please help me ><


The text files use ∥ as the separator.

I want to find in all text files and delete everything between the last, second-to-last, and third-to-last ∥ separators.
Example as follows:

Before processing:


1∥PowerDirector 6 practical online tutorial∥Who am I∥123@yahoo.com.tw∥This webpage cannot be linked<br>∥2007/10/11 10:55∥219.84.136.241∥d6wRPnMHgj46Q∥1192071350∥QBIFBW3Q∥

After processing:

1∥PowerDirector 6 practical online tutorial∥Who am I∥123@yahoo.com.tw∥This webpage cannot be linked<br>∥2007/10/11 10:55∥219.84.136.241∥

Simply put, as long as everything after 219.84.136.241 can be deleted, that's fine.
But 219.84.136.241 is the user's IP, so it is an irregular string.


Please help, thank you very, very, very much, it's urgent ><
Many thanks

[ Last edited by leo1984 on 2007-10-31 at 02:03 AM ]

Thank you very much for your kind help.
But if I change Oldlist.txt to *.txt, that means opening all text files.
Then how can I save the modified text files directly themselves, without outputting Newlist.txt
instead?

[ Last edited by leo1984 on 2007-10-31 at 02:49 AM ]

In batch files you can't directly read from and save to the same text file at the same time, otherwise the new data will directly overwrite the old data.

Test it yourself first.

@echo off

md Temp

for /f "delims=" %%f in ('dir /on/b "*.txt"') do (

  echo.>Temp\%%~nfNew.txt

  for /f "tokens=1,2,3,4,5,6,7 delims=∥" %%i in (%%f) do echo %%i∥%%j∥%%k∥%%l∥%%m∥%%n∥%%o∥>>Temp\%%~nfNew.txt

)

pause

[ Last edited by zh159 on 2007-10-31 at 09:08 AM ]

Thank you very much for your help, zh159, it has already been solved successfully.
I also wish you all the best ^^

Also thanks to abcd, but I tested that section too, and it seems it only searched for the string and didn't really do anything. Thanks to you as well ^^

Why is the OP's text in Traditional Chinese? It feels so awkward to read!

Sorry,
because I'm a user from Taiwan, I can only type in Traditional Chinese ^^"

Not just Taiwan, Hong Kong uses Traditional Chinese too (I'm from the mainland ^_^)

Simplified Chinese is convenient for writing, but Traditional Chinese may show more skill in calligraphy; Simplified should be promoted, but Traditional must not be forgotten ^_^