A family of Microsoft word processing software products for creating web, email, and print documents.
Did this worked before?
This might be a limitation with the SAP program, check with SAP for more help.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
am trying to export data from SAP to Ms Word but keep on getting the data fields must be separated from each other by a character called a field delimiter.
A family of Microsoft word processing software products for creating web, email, and print documents.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Did this worked before?
This might be a limitation with the SAP program, check with SAP for more help.
What format are you choosing when exporting?
What file extension does the export file have?
How many columns of data are you exporting?
Just to review:
If it's a "text" format, rather than something like an Access .mdb format, Word expects a tabular format where
a. the first line contains a list of column headers. Let's say there are "n" column headers. The list has a "field delimiter" between each pair of headers. e.g. if it is like this
columna,columnb,columnc,columnd
then the field delimiter is the "," character and there are 4 columns
b. at the end of the line is a "record delimiter". This is typically a carriage return, line feed, or carriage return/linefeed combination
c. each subsequent line contains one record, each with the same number of values as there are column headers, using the same field delimiter and terminated by the same record delimiter.
So, e.g., you might have
columna,columnb,columnc,columnd
rec1value1,rec1value2,rec1value3,rec1value4
rec2value1,rec2value2,rec2value3,rec2value4
Word tries to guess what character you are using as a field delimiter (and in some cases, as the record delimiter), but may not be able to do so for a number of reasons.
Further, if you have a value that contains the field delimiter or record delimiter, you have to surround that value by another delimiter called the "text delimiter", which is typically a double-quote character ". If a value contains the text delimiter, you have to double up the text delimiter. So, e.g. if value rec2value3 is a multiline address such as
"Dunmergin"
2a, Field Lane
then rec2 would need to be like this:
rec2value1,rec2value2,"""Dunmergin""
2a, Field Lane",rec2value4
If your data is primarily numeric and your locale uses "." as the decimal point character, there is little problem including numbers with decimal points, e.g.
21.3,45.45,23,1.0
However, if your locale uses ",", you either have to put text delimiters around each number, or change the field delimiter.