Hi,
I have an odd issue with txt file from SAP.
The issue happens when a ref key 3 (or I assume any other free text field) includes hash # at the end of the string as attached.
The txt file looks normal and this hash is not visible, but when importing it to excel, either by VBA or manually, it always separates the row by # and moves the rest on the next row.
Has anyone else experienced this and managed to work around it?
Thanks a lot.
I don't know what is happening here and I don't see the "#". I observed something following the Ref key 3 "MCA052318" that may help some one identify the cause.
In the text file ... opened in Notepad ... the field that contains the MCA052318: starting at the far right end of that field and arrowing left, when the cursor gets to the 8 I would expect the next left arrow to be to the right of the 1. It does not do that. It stays just to the right of the 8 until the next left arrow. So something is there but I can not tell what it is. Attempts to apply CODE/MID indicate nothing.
Last edited by FlameRetired; 09-16-2018 at 10:25 PM.
Dave
The character is a Hex(OA) linefeed character without the Hex(0D) carriage return
4D 43 41 30 35 32 33 31 38 0A 20
M C A 0 5 2 3 1 8 ._
I think the file would have to be opened via vba directly from disk using "LineInput" etc. and searched for a 0A without the preceding OD. They are almost always paired: 0D0A
Last edited by protonLeah; 09-16-2018 at 11:53 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks