How can I convert pipe delimited file to csv format - VisualCron - 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
Free 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 to Convert PDF File to EPUB Format? Solution (General problem solving) by Jonah Scott 2025-11-07T07:01:54Z
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 Import PST to Thunderbird (General problem solving) by kyla jain 2025-11-08T08:50:23Z

Users browsing this topic

Guest

© SMA Technologies. All Rights Reserved, 2025 Version: 12.1.6.f748df8

Terms & Conditions

Scroll to Top