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"
)
Open in new window
However my output file is coming out like this
"999859","0000000000000000000000000","PATIENT NOT FOUND"
"999380","0000000000000000000000000","PATIENT NOT FOUND"
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'
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!
Open in new window