Consulting

Results 1 to 17 of 17

Thread: Editing Text Files using VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Mar 2018
    Location
    Allen
    Posts
    7
    Location

    Question 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
  •