![]() I tried all of the below as well InStr(1, FileContents, vbLf)īut none of these found the carriage return character. Step 3: Press the Alt key and Enter key together. Step 2: Put the cursor at the specific position that you want the long sentence wrapped. Step 1: Double clicking the cell you will work with, and get to edit it. ![]() To isolate the carriage return character but I end up with a character from the next line, so that doesn't work either. Now you need to add carriage return or hard return manually in cells. I have tried using : Asc(Mid(AdsFileContentsX, 3, 1)) My application depends on finding this carriage return, and now it doesn't work. ![]() Something somewhere upstream of my application has changed the assumed carriage return character 'vbLf' cannot be found, however it is clearly there when viewing it in Notepad++. Where FileContents is the whole text file after the '=' symbol. So far, this line of code worked to find the text between the '=' sign and the end of line InStr(1, FileContents, vbLf) ![]() A particular line could look like this: =50 My application searches for a particular Setting and returns them to the user in plain English. These files consist in Finite Element Modeling simulation settings, where each line in a 20k+ text file is an individual setting. I have an application written in Excel/VBA which reads text files written in UNIX.
0 Comments
Leave a Reply. |