Striping variable text out of a text file?

[mr_Frank]

Hi,

I've got a script which is outputting a load of user attributes from an Active Directory.

I've got to it to a point where i have the contents of the text file as follows:
>sAMAccountName: username1
>sAMAccountName: username2
>sAMAccountName: username3
>sAMAccountName: username4
>sAMAccountName: username5
...
..
.

Is there some why to strip out the ">sAMAccountName: " bit so i'm just left with the usernames?

Thanks

[Squashman]

Post the script you are using now and we can simplify it for you.

[mr_Frank]

Hi,

I'm just doing a :

type adoutput.txt | find "sAM"

to get me that output

[Squashman]

And the output is exactly as you posted? It has a > at the beginning of each line?

[mr_Frank]

yep, the actual file contents are as follows, each line has the '>' symbol at the beginning:

>cn: John Smith
>homeDirectory: \\server\username1
>sAMAccountName: username1

[foxidrive]

This should do it. (untested)

Code: Select all

@echo off
for /f "tokens=1,*" %%a in (' type adoutput.txt ^| find "sAM" ') do echo %%b

[Squashman]

This should do it. (untested)

Code: Select all

@echo off
for /f "tokens=1,*" %%a in (' type adoutput.txt ^| find "sAM" ') do echo %%b

I was thinking that maybe it should find "sAMAccountName" in case some other line might have those 3 letters in it.

[mr_Frank]

Perfect works a treat - cheers all

[mr_Frank]

do you know how the same result could be obtained if the data I wanted was at the end of a line of text like:

\\domain.com\customer\region\site\folder\username1
\\domain.com\customer\region\site\folder\username2
\\domain.com\customer\region\site\folder\username3
\\domain.com\customer\region\site\folder\username4

So I want to be left with just username1,2,3,4 as output?

[abc0502]

Try This:

Code: Select all

@echo off
for /f "tokens=1,2,3,4,5* delims=\" %%a in ('type "adoutput.txt"') do echo %%f

%%a is for domain.com
%%b is for customer
%%c is for region
%%d is for site
%%e is for folder
%%f is for usernameX

[mr_Frank]

Spot on - awesome - thanks

[foxidrive]

In your case you can also use a documented command like this, to get the usernames:

Code: Select all

@echo off
for /f "delims=" %%a in (file.txt) do echo %%~nxa

[mr_Frank]

even better - nice one