Question & Answer
Question
How to create a comma delimited output file (.csv for MS Excel format) (SCI23688) *|* -3954E112387D3C038525791800231F77- *|*
Answer
Technote (FAQ)
Question
How to create a comma delimited output file (.csv for MS Excel format) (SCI23688)
Answer
When creating a EDI Standard to flat file delimited map do the following:
1.????????Create new map
2.????????Select Delimited (ANSI etc) standard for the input side of the map
3.????????Select the option to Customize to select the appropriate standard
4.????????For the Output select Delimited but DO NOT customize
This creates an EDI to Delimited (flat file with delimiters) map.
After the map is generated to get commas () in the data at the top of the OUTPUT side of the map:
1.????????Right-click select Properties
2.????????Go to the Delimiters tab
3.????????Check specify delimiters
4.????????Place commas for all the delimiters
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Commerce | Sterling Gentran:Server for Microsoft Windows | Mapping and Translation |
Historical Number
PRI825
Product Alias/Synonym
Fact
Gentran:Server for UNIX All Releases
Gentran:Server for Windows All
Releases
GENTRAN:Server for Windows NT All Releases
Application
Integration
Inbound data (export map)
SCI23688
Goal
How to create a comma delimited output file (.csv for MS Excel format)
Was this topic helpful?
Document Information
Modified date:
12 October 2021
UID
ibm10765337