+ Reply to Thread
Results 1 to 4 of 4

controlling the format of a "Line Break"

  1. #1
    Forum Contributor
    Join Date
    03-27-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    290

    controlling the format of a "Line Break"

    If I create a text file using VBA with the method of:

    Please Login or Register  to view this content.
    what is determining whether the line break ( or Chr(10) ) is in which unicode format?

    The problem I have is opening text files in both unix and microsoft without having any issues with line breaks.
    Windows uses: LF VT FF CR as new lines
    Unix uses : LS and PS as new lines

    so you can see the problem lies with both of their default programs using different line breaks.

    So If im using windows, how can i assure that my Chr(10) is going to be a line break when opening that text file in notepad?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: controlling the format of a "Line Break"

    if you run the code in Windows you will always get a Windows linefeed character I reckon
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    03-27-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: controlling the format of a "Line Break"

    no, i had a file which I produced in unix line feed. I think the origional document was created by unix and thats why the result is in unix line feed but im not sure.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: controlling the format of a "Line Break"

    I don't think you read what Josie said. She said that if you run that code in Windows you will get a Windows linefeed. If the file is created in Unix then you will equally get a Unix linefeed.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date format of just "st" "nd" "rd" and "th" with text included
    By notrandom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2013, 05:45 PM
  2. [SOLVED] Problem creating Line Chart from columns "date" and "money"
    By brosef in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-05-2012, 09:01 AM
  3. Replies: 4
    Last Post: 12-29-2009, 08:11 PM
  4. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  5. select & format "single" axis line in charts
    By Guru Guy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2006, 11:40 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