New line as a delimeter of FOR loop

Question

I am new to batch script, and I am trying to parse a file that has key value (kind) of pairs delimited by new line. For example:

the value of abc
1234
the value of def
5678
the value of ghi
9876

I would like to read this file using new line as delimited so that I can access the values.

Something like

for /f "tokens=1,2,3 delims='\n'" %%i in ('findstr /C:the value of abc 'filepath') do echo %%j

Which do you want? Batch or powershell? They are two separate languages. Do you want all lines parsed or just a part of the file? — Frode F., Mar 26 '13 at 15:53
Possible duplicate of [bat script, what delim to use to to read text file line by line](http://stackoverflow.com/questions/6721989/bat-script-what-delim-to-use-to-to-read-text-file-line-by-line) — Suncatcher, Nov 21 '16 at 08:31

score 5 · Answer 1 · answered Nov 21 '16 at 08:27

5

I just put it here as an option:

for /F delims^=^ eol^= %%i in ('findstr /C:the value of abc 'filepath') do echo %%i

answered Nov 21 '16 at 08:27

Suncatcher

10,355
10
52
90

At least for what I was doing, `delims^=^ eol^=` worked perfectly, can't say I understand what it means though! – Dylan Nicholson May 11 '23 at 04:41

score 3 · Answer 2 · answered Mar 26 '13 at 16:22

You can't set 'new line' as delimiter. Try this:

@echo off &setlocal
for /f "tokens=1*delims=:" %%i in ('findstr /NC:"the value of abc" "filepath"') do set /a count=%%i
if defined count for /f "skip=%count%tokens=1*delims=:" %%i in ('findstr /N "^" "filepath"') do if not defined value set "value=%%j"
echo.%value%
endlocal

score 3 · Answer 3 · answered Mar 26 '13 at 18:10

@ECHO OFF
SETLOCAL
SET "prevline="
FOR /f "delims=" %%z IN (tvabc.txt) DO (
 IF DEFINED prevline (
  FOR /f "tokens=1-6" %%a IN ('echo %%prevline%% %%z') DO (
   ECHO %%a %%b %%c %%d %%e %%f
   )
  SET "prevline="
  ) ELSE (SET prevline=%%z)
)

should do the job, if you require each token from two successive lines to be output. Would be much easier if we had a listing of the required output rather than having to guess from code that doesn't work.

Essentially, this code saves the contents of one line then detects that the second has been read by the fact that the variable holding the previous line is defined. Under those circumstances, for/f is used to tokenise the concatenation of the two lines.

score 2 · Answer 4 · answered Mar 26 '13 at 16:40

Not sure what you're going to do with those Name/Value pairs after you get them, but if you're going to do it in Powershell, do it right and start by creating objects:

$file = 'c:\somedir\somefile.txt'

[regex]$regex = @'
(?ms)the value of (\S+)
(\d+)
'@

#Choose one
$text = Get-Content $file -Raw  # V3 Only
$text = [IO.File]::ReadAllText($file)  # V2 or V3


$regex.matches($text) |
foreach {
   New-object PSObject -Property @{
                                   Name = $_.groups[1].value
                                   Value = $_.groups[2].value
                                  }
        }|
  Select Name,Value |
  Format-Table -AutoSize

Name Value
---- -----
abc  1234 
def  5678 
ghi  9876

score 0 · Answer 5 · edited Mar 26 '13 at 16:48

0

What do you think of that? In powershell:

(get-content .\essai.txt)[(Select-String .\essai.txt -Pattern "the value of abc").LineNumber]

It displays the next line after the pattern.

edited Mar 26 '13 at 16:48

Kirk

16,182
20
80
112

answered Mar 26 '13 at 16:22

plunkets

510
1
6
13

It's not batch script (as stated in question), it's PowerShell. – Suncatcher Nov 21 '16 at 08:25

score 0 · Answer 6 · answered Nov 02 '19 at 15:05

0

I normally use the given batch command, to read each line in file

FOR /F "delims=" %%G IN (test.txt) DO (
    ECHO %%G
)

Here, "delim=" does the trick.

answered Nov 02 '19 at 15:05

Abhishek Rathore

1,016
1
11
13

New line as a delimeter of FOR loop

6 Answers6

Linked