OnDemand User Group

Support Forums => Other => Topic started by: Steve Lance on June 01, 2021, 04:58:44 AM

Title: Pipe delimited
Post by: Steve Lance on June 01, 2021, 04:58:44 AM

We have been using comma delimited csv files and CMOD converts to excel.  A user is requesting to use pipe delimited.  How can we use pipe delimited files? 

Title: Re: Pipe delimited
Post by: Justin Derrick on June 01, 2021, 01:03:14 PM

CSV is a format that Excel recognizes natively.  What tool are they intending to use to read these files?

If they're concerned that some of the fields contain commas, you can fix this by quoting them:

Code: [Select]

Derrick,Justin,123-456-7890  # Three fields

Code: [Select]

"Derrick,Justin","123-456-7890" # Two fields
-JD.

Title: Re: Pipe delimited
Post by: Steve Lance on June 02, 2021, 05:27:16 AM

They intend to read these files from OnDemand.  There is not a way to use pipe delimited files?