edit Text files

killavirus · 17 Oct 2008 10:01

im looking for a way to remove all spaces and special charachters from a text file any ideas ???

e.g.
from

Server Name            Remark

-------------------------------------------------------------------------------
\\JAYDELL1                                                                     
\\LIONEL                                                                       
\\OPTIMATERM                                                                   
\\ROB                  Optima Optiplex 1                                       
\\SBSERVER2003                                                                 
\\VAIO-LIONEL                                                                  
The command completed successfully.

to

JAYDELL1
LIONEL
OPTIMATERM
ROB
SBSERVER2003
VAIO-LIONEL

I can get as far as removing the odd line etc e.g. the first line but am having difficulty figuring out how to do the rest

bluesxman · 17 Oct 2008 13:13

I'm guessing you're doing a "net view" there ... you could use the "for /f" command to achieve the results you want.

In a script, something like this should do it:

for /f "usebackq tokens=1 skip=3 delims=\ " %%a in (`net view ^| find /v "The command completed successfully."`) do echo:%%~a

Last edited by bluesxman (17 Oct 2008 13:16)

killavirus · 17 Oct 2008 13:36

lol you make this look easy !!!

What is the usebackq ?
i havnt seen that before ...

bluesxman · 17 Oct 2008 16:59

It changes the semantics of the "for" command, such that it uses back-quotes >`< rather than straight quotes >'< to wrap around a command, plus a couple of other bits. I do a lot of "for" work from text files, so you generally need it to allow long file names, so use it by force of habit.

killavirus · 17 Oct 2008 18:21

thank you
A real good tidbit of information there

SS64 Forum

#1 17 Oct 2008 10:01

edit Text files

#2 17 Oct 2008 13:13

Re: edit Text files

#3 17 Oct 2008 13:36

Re: edit Text files

#4 17 Oct 2008 16:59

Re: edit Text files

#5 17 Oct 2008 18:21

Re: edit Text files

Board footer