Extract string between two parameters within xml file using batch preferrably

Question

I've been struggling with extracting data between two strings in an xml file. I need to extract the data between two tags.

The two tags are:

I have tried code that i have found that extracts string between two tags, but the tags are usually simpler, like the one below. Also the tags i want to extract data between contains quotation marks.

I have tried using the following code, but i am unable to make it work for my example.

@ECHO Off
SETLOCAL
SET "sourcedir=C:\Users\a067935\Desktop\Wheel alignment"
SET "filename1=%sourcedir%	est.xml"
FOR /f "delims=" %%a IN ('FINDSTR /i /L /c:"" "%filename1%"') DO SET "name=%%a"
SET "name=%name:*=%"
FOR /f "delims=<" %%a IN ("%name%") DO set "name=%%a"
ECHO "%name%"
GOTO :EOF

Example xml file



    
        2017-07-05 14:27:18.979
        f558c39c-cb19-439a-97fb-2c2dfd4a0f2e
    
    
        
            1
            a262236
            
                
                    
                        KD
                        01KD000001
                    
                    
                        KD
                        0000160751
                    
                    
                        0000160751_KD
                    
                    
                        0000160751_KD
                    
                    
                        KD-01KD000001
                    
                    
                        M
                        943524
                    
                    
                        YVgfhffj66943524
                    
                
            
            
                
                    0
                    1
                    1
                    1
                    
                        
                            F1,D1,D2
                            R
                            Y
                            590
                            445
                            3
                            D1
                            375
                            -1295
                            1190
                            0,2
                            0
                            1
                            1,5
                            0
                            0,5
                            1
                            2,2
                            850
                            22,5
                            3600
                            385-65
                            0
                            315-80
                            Y
                            22,5
                            Set
                            0,2
                            Measured
                            1370
                            0,2
                            315-80
                            Y
                            22,5
                            0
                            Measured
                            0
                            2
                            Y

Magoo · Accepted Answer

@ECHO OFF
SETLOCAL
SET "sourcedir=U:\sourcedir"
SET "filename1=%sourcedir%\q45583503.txt"

FOR /f "tokens=1-7delims=<=>" %%a IN (
 'findstr /R "ns3:UTF8String.id=.ChassisNo." "%filename1%" '
) DO ECHO chassisno=%%d
)

GOTO :EOF

You would need to change the setting of sourcedir to suit your circumstances.

I used a file named q45583503.txt containing your data for my testing.

Using the restricted-regular-expression facility of findstr with the delims capacity of for/f.

Extract string between two parameters within xml file using batch preferrably

Answers (1)

Related Questions