Batchfile looping through CSV file?

I'd like a .bat file to loop through the contents of a simple csv text file but my knowledge is limited to simple in-bat loops like 'FOR %%G IN (AA BB CC) DO echo %%G'

I have a text file fruit.txt with two CSV columns of data and n rows, something like

apple,5
orange,3
durian,0

and want to basically grab the first line, parse the fruit-name and number-sold, and print them out.

No clue how to do this. I think its possible, but I havent done .bat in like 30 years?

Answer

Oops figured it out!

@echo off
setlocal enabledelayedexpansion

REM Set the path to your CSV file
set "file=C:\Users\arod\Desktop\fruit.txt"

REM Read the file line by line
for /f "tokens=1,2 delims=," %%A in (%file%) do (
    set "fruit=%%A"
    set "quantity=%%B"
    echo Fruit: !fruit! - Sold: !quantity!
)

endlocal
pause