Results 1 to 4 of 4

Unicode character creates a line break

Threaded View

mikke Unicode character creates a... 01-13-2015, 02:38 PM
Kenneth Hobson Re: Unicode character creates... 01-13-2015, 03:38 PM
mikke Re: Unicode character creates... 01-14-2015, 02:35 AM
Marc L Hi ! 01-15-2015, 08:48 PM
  1. #1
    Registered User
    Join Date
    12-07-2008
    Location
    Helsinki Finland
    Posts
    11

    Unicode character creates a line break

    Hi,

    I'm using line input statement to replace specific unicode characters. The attached file with ChrW(269) causes any how line-breaks eventhough I've tried the replace statement. What to do?

    Sub test()
    
    Open "C:\Temp\test.csv" For Input As #1
    Open "C:\Temp\ready.xls" For Output As #2
    Do While x < 1000
    On Error GoTo ender
    Line Input #1, vstring
    
    If Not (vstring = "") Then
    vstring = Replace(vstring, ChrW(269), ChrW(99))
    End If
    x = x + 1
    Write #2, vstring
    Loop
    ender:
    Close #1
    Close #2
    
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 12-18-2016, 03:04 PM
  2. Replies: 12
    Last Post: 06-22-2016, 01:11 PM
  3. Concatenate with a Unicode Character
    By Landon Y in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2014, 03:59 PM
  4. [SOLVED] Break a line of text at specfied character count
    By kazphilips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2013, 12:45 AM
  5. Macro Add line break after character
    By Tybalt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2013, 09:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1