How to Tody Up Piped files

Archived from groups: microsoft.public.windowsxp.general (More info?)

Anyone know how to tidy up piped files ? For example if on the command line
you type:

net user>c:\users.txt

The txt file will have a list of users setup on the PC but the way its
setout is in columns of 3. I want a single column for a lookup table say.
Anyone got any suggestions before I start trying to script something ?

Archived from groups: microsoft.public.windowsxp.general (More info?)

"Jingle Man" <Jingle Man@discussions.microsoft.com> wrote in message
news:FEF2E18B-5B62-45F4-B016-9CA82325B43F@microsoft.com...
> Anyone know how to tidy up piped files ? For example if on the command
> line
> you type:
>
> net user>c:\users.txt
>
> The txt file will have a list of users setup on the PC but the way its
> setout is in columns of 3. I want a single column for a lookup table say.
> Anyone got any suggestions before I start trying to script something ?

[1]@echo off &setlocal enabledelayedexpansion
[2]for /f "skip=4 delims=" %%i in ('net users^|find /v "The command
completed" ') do (
[3] set ynu=%%i
[4] echo !ynu:~0,25!
[5] if not "!ynu:~25,25!"=="" echo !ynu:~25,25!
[6] if not "!ynu:~50,25!"=="" echo !ynu:~50,25!
[7] )

Each line begins [number]. Lines will be wrapped in transmission and
need to be rejoined. The [number] at the beginning of each line needs
to be removed.

Note that in line 2, FIND filters out the line "The command completed"
(which will be the last line generated by the "Net users" command.) I
suspect (but do not KNOW) that usernames cannot contain a dot. If the
usernames CANNOT contain dot, then use "." in place of "The command
completed" (since the "The command completed" line is terminated by a
dot....)

Pop a

>>filename

after each ECHO and you've got your list in your preferred form.

For batch methods, try alt.msdos.batch.nt or
microsoft.public.win2000.cmdprompt.admin

HTH

....Bill