cmd - Error: "|" was unexpected at this time batch script

Question

When I run this script, I receive

| was unexpected at this time.

This is code:

@ECHO Off

REM Mapeo de unidad U, path de usuario

    net use u: \serverusuarios\%username%
pause
REM  ***** Description group ****

for /f %%i in ('net user %username% /domain | find /i /c Group') do set RESULT=%%i

echo %RESULT%

pause   

In for sentence, i use " and ', but I still got error.

Answer 1

The condition inside the for must be parsed by the batch parser before it can pass it to the IN() clause as an executable command and since the pipe is a special character in DOS, you need to use escape character(^) before pipe to preserve it during the initial batch parsing, as shown below:

for /f %%i in ('net user %username% /domain ^| find /i /c Group') do set RESULT=%%i