How can I convert pipe delimited file to csv format - VisualCron - Forum

Community forum

Manu Khurana
2022-05-16T04:45:51Z
I need to create a task to receive pipe delimited file in a shared folder and then convert it to CSV format.
Please help how it can be done.
Thanks!
ErikC
2022-05-17T07:22:06Z
Hi,

I think you can do that with a powershell task:

$csv = Import-Csv "source.csv" -Delimiter "|"
$csv | Export-Csv -Path "destination.csv" -Delimiter "," -NoTypeInformation


Regards
Erik
Uses Visualcron since 2006.
Michael Fjellström
2022-05-23T14:04:31Z
Thanks Erik!

I hope that solution works for you Manu.
Scroll to Top