Author Topic: Pipe delimited  (Read 1723 times)

Steve Lance

  • Jr. Member
  • **
  • Posts: 33
    • View Profile
Pipe delimited
« 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? 

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Pipe delimited
« Reply #1 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Steve Lance

  • Jr. Member
  • **
  • Posts: 33
    • View Profile
Re: Pipe delimited
« Reply #2 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?