-
Editing Text Files using VBA
Hello VBA Experts!
I am trying to clean up a data file that imported some bullets and treats them like carriage returns.
I am able to Open strFile For Binary Access etc. and delete the unwanted carriage returns and line feeds.
The bullets are shown as a quotation mark followed by a tab ( e.g., "-> ) at the beginning of each line. Example: "->test -> test ->test
So I only need to delete the first tab proceeded by a quotation mark.
The code I have been trying unsuccessfully is:
If InStr(1, strBuffer, "CHR(34)") = 1 Then
strBuffer = Replace(strBuffer, vbTab, "")
End If
Is there VBA code for replacing the "-> at the beginning of the line with a ""
Any help appreciated with this!
Thank you,
RBollinger
Last edited by ROBBOLL; 03-18-2018 at 12:04 PM.
Reason: Add introduction
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules