Convert .txt file to .csv file with single quotations

Hi All,

I'm using the following .bat file to convert a .txt file to a .csv file

@echo off
setlocal enabledelayedexpansion

for /f "tokens=*" %%a in ('type "%~1"') do (
   set line=%%a
   echo "!line:|=","!">>"%~2"
)

Select all Open in new window

However my output file is coming out like this

"999859","0000000000000000000000000","PATIENT NOT FOUND"
"999380","0000000000000000000000000","PATIENT NOT FOUND"

Select all Open in new window

When i need it to be like this, essentially replacing the surrounding double quotes with single quotes.

'999859','0000000000000000000000000','PATIENT NOT FOUND'
'999380','0000000000000000000000000','PATIENT NOT FOUND'

Select all Open in new window

Is there any way to modify the .bat file script to accomplish this? Possibly doing a find and replace on the output file?

Thanks for the assistance!