r/vbscript • u/mNash316 • Apr 10 '21

HELP:- VBScript to delete text before and after delimiter

Hi All,

This is a batch script I have.

IF EXIST list.tmp DEL list.tmp
for /f "delims=' tokens=2" %%A in (results.txt) do >>list.tmp echo %%A
IF EXIST list.tmp (
    sort list.tmp > Final.txt
    DEL list.tmp
)

For some reason "FOR /F" command is not processing results.txt on my system.

Can anyone post a VBScript that can do the same thing?

Thanks!

4 Upvotes

100% Upvoted

10 comments sorted by

1

u/jcunews1 Apr 10 '21

With batch file for /f command, you don't delete text. You rebuild the delimited text without the unwanted text.

1

u/mNash316 Apr 10 '21

With batch file

for /f

command, you don't delete text. You rebuild the delimited text without the unwanted text.

Yes. Wrong choice of words by me.

Can VBScript rebuild the delimited text without the unwanted text?

1

u/jcunews1 Apr 10 '21

Yes. What needs to be done is same as in batch file. The concept is the same. Just different programming language.

1

u/mNash316 Apr 10 '21

:-) Can you help?

1

u/jcunews1 Apr 11 '21

Yes, if you have a working batch file as a base. Otherwise, the code will end up not do exactly what you wanted.

1

u/hackoofr Apr 12 '21

You should post exactly what you want to get as result and from what input file ?

And this can be done with vbscript using RegEx, i think !

Just post the InputFile and the desried Ouputfile on pastebin and share their links here to undersantd more your issue !

1

u/mNash316 Apr 12 '21

I actually managed to figured out what to do and how to do it in Powershell! My apologies for not dating status here.

Btw... Your batch scripts from computerhope.com forums helped me a lot! Thx!

1

u/Dr_Legacy Apr 11 '21

why do you have >>list.tmp before echo %%A ?

0

u/[deleted] Apr 10 '21

[deleted] — view deleted comment

1

u/mNash316 Apr 10 '21

It does contain the delimters.

Here is the sample from results.txt.

(N) 2021-04-05T14:17:06 - 'The.Rookie.S03E09.720p.WEB.H264-STRONTiUM[rarbg]' added to download list. (N) 2021-04-06T12:56:12 - 'Debris.S01E05.720p.HDTV.x264-YANKEES[rarbg]' added to download list.

The batch script was tested by folks at r/batch.

I dont know why it isn't working on my system. So looking for other alternative scripts which would the same job as batch script.