Share via

data fields must be separated from each other by a character called a field delimiter

Anonymous
2011-05-05T10:13:59+00:00

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.

Microsoft 365 and Office | Word | For home | Windows

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.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2011-05-06T06:38:27+00:00

    Did this worked before?

    This might be a limitation with the SAP program, check with SAP for more help.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2011-05-06T07:33:17+00:00

    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.

    Was this answer helpful?

    0 comments No comments