Remove an 'Equals' symbol from text string

Question

I'm running a WMIC lookup against a series of remote client machines, pulling in Model and serial number.

For /F "tokens=*" %%b in ('wmic /node:%device% computersystem get Model /value^|find "Model"') do Set model=%%b

FOR /F "tokens=*" %%c in ('wmic /node:%device% bios GET serialnumber /value^|find "SerialNumber=" ') do set Serialnumber=%%c

The problem I have is that (for example) %serialnumber% is set to:SerialNumber=CNU8424GP3

I don't want the 'Serialnumber=', I just want the Serial number itself.

The only way I've found of stripping this is:

set SerialNumber=!serialnumber:SerialNumber=!

but this leaves an equals sign at the beginning of the line. So the final output is =CNUBFZXXY, what I would like to do is to remove the leading =, and I haven't been able to.

Any Suggestions?

Patrick Cuff · Accepted Answer · 2010-09-23 11:08:45Z

3

Add delims== to your for statements and change tokens=* to tokens=1-2. The values you want will then be in the second for loop variables:

For /F "delims== tokens=1-2" %%b in ('wmic /node:%device% computersystem get Model /value^|find "Model"') do set model=%%c
For /F "delims== tokens=1-2" %%c in ('wmic /node:%device% bios GET serialnumber /value^|find "SerialNumber=" ') do set Serialnumber=%%d

answered Sep 23, 2010 at 11:08

Patrick Cuff

30.1k12 gold badges70 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Patrick Over a year ago

Thanks, I can see what you're trying to get at here, however the exact example you've given above gets the info from >before< the = sign. Ie the normal output is SerialNumber=CNXXXBFW, and your code sets the variable as SerialNumber=SerialNumber, selecting only the first of these tokens. I've tried altering the Delims and Tokens but can't get it to just read the second token only. Any further ideas? And thanks for taking the time to look.

Patrick Cuff Over a year ago

What value %device% have on your system? I don't have this var on my system, so I used localhost in place of %device% and this code works. I get "Latitude E6400" for %model% and a proper value for %SerialNumber%. Are you capturing all the text above, even the text that scrolls right? The set statements should be using %%c and %%d respectively.

Patrick Over a year ago

%device% is read in from elsewhere and is a hostname for a networked machine as I'm running this against a list of remote devices.

Patrick Over a year ago

Interestingly I've just run this against my own machine, and as you say, it works fine. Strange. I'm wondering if I can do this with a PSExec instead. Thanks for your help :)

Patrick Cuff Over a year ago

Could the output from wmic be different for a remote machine than it is for a local machine? You may have to play with the tokens to get at what you need. Conceptually, my solution should work, it's just a matter of parsing the output so you can grab what you need.

|

mousio · Accepted Answer · 2011-04-06 22:47:46Z

2

Either split up the result using a for-statement with "delims==" (already answered), or trim up to and including the equal-sign – your example code was very close already:

set SerialNumber=!SerialNumber:SerialNumber=!
set SerialNumber=!SerialNumber:~1!

edited Apr 6, 2011 at 22:47

answered Apr 6, 2011 at 22:29

mousio

10.4k4 gold badges38 silver badges46 bronze badges

Comments

CodeMonkeyKing · Accepted Answer · 2010-11-30 06:36:53Z

1

The snippet below will allow you to remove the first and last character. I've played a trick here and added a matching '=' at the end of the string (NOTE: I could have used any character). I couldn't find a way to get up to the last character, so the trick is to just add on any character at the end of the variable and then strip it with the 1,-1 which means skip the first charcter and the negative value for the right side means 'counting back from the right'.

set serialnumber=%serialnumber%=
set serialnumber=%serialnumber:1-1%

Hope this helps people looking to hack DOS batch scripts in the future. A good short description of string manipulation can be found here: DOS String Manipulation

answered Nov 30, 2010 at 6:36

CodeMonkeyKing

4,6721 gold badge34 silver badges34 bronze badges

Comments

Edoctoor · Accepted Answer · 2010-09-30 14:38:06Z

0

It is possible to retrieve specific characters from a string variable.

Syntax %variable:~num_chars_to_skip% %variable:~num_chars_to_skip,num_chars_to_keep%

This can include negative numbers:

  %variable:~num_chars_to_skip, -num_chars_to_skip%
  %variable:~-num_chars_to_skip,num_chars_to_keep%

Example

 SET _test=012345
 SET _result=%_test:~1,6%
 ECHO %_result%          =12345

answered Sep 30, 2010 at 14:38

Edoctoor

1811 gold badge3 silver badges11 bronze badges

Comments

Tomcat Cruiser · Accepted Answer · 2017-12-18 14:08:54Z

0

Just do this instead it's much easier. USE QUOTATION MARKS AROUND BOTH VARIABLE AND STRING on the IF statement

IF "%VARIABLE%"=="equalsign=123456" goto Z

:Z

SET VARIABLE=%VARIABLE:~10%

echo %VARIABLE%

The output should be 123456. No equal sign.

That should do it. Seriously, that was really making me go nuts trying to figure that out. Someone else recently helped me with that. Never thought it would be so easy lol.

edited Dec 18, 2017 at 14:08

answered Dec 18, 2017 at 13:40

Tomcat Cruiser

134 bronze badges

Collectives™ on Stack Overflow

Remove an 'Equals' symbol from text string

5 Answers 5

7 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

7 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related