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

Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

Manu Khurana
Free support Topic Starter

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!

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

ErikC
Paid support

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

Edited by user 2022-05-19T06:54:05Z | Reason: typo

Uses Visualcron since 2006.

Michael Fjellström
Official support

2022-05-23T14:04:31Z

Thanks Erik!

I hope that solution works for you Manu.

Similar Topics

How can I convert a .txt file to "UNIX" file format using a VC Script (General problem solving) by jpplaster 2011-03-29T01:04:30Z
How can I support VisualCron? (FAQ - general) by Support 2015-12-29T13:23:15Z
sftp download csv file in UNIX format? (General problem solving) by Support 2014-02-10T11:01:28Z
How can I add Active Directory group (General problem solving) by bbusse 2014-07-25T23:56:44Z
[Solved] How do I change port from 16444? (can I?) (Installation / Upgrade) by joeriks 2012-02-15T13:45:21Z

Users browsing this topic

Guest

© VisualCron

Scroll to Top