Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
try fm 'SF_SPECIALCHAR_DELETE' to delete the special characters or identify the special characters and replace them with the right characters using 'replace all occurences of'
First of all, it is not an ABAP question (but it's technical).
# is the character SAP is using when a "code point" (byte(s) storing one character) has no meaning in a target code page. You should use CG3Z with "text mode", which corresponds to a OPEN DATASET ... IN TEXT MODE ENCODING DEFAULT (refer to the ABAP doc for more info). If your SAP system is Unicode, it means that the file must be UTF-8. If your file is not UTF-8 (for instance Latin 1, ...), some bytes cannot be interpreted and are converted to #.
Sorry, my answer was incorrect, OPEN DATASET was about writing the file, but the issue was about reading the file. SAP reads the file and interprets its bytes according to the code page of the frontend. There would be a mismatch if some of the characters of the file were encoded in another code page, which would then be replaced with #. Another problem could have been that your SAP system is not Unicode, so it cannot store all Unicode characters and replace them with #.
Bluesky
