Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Unanswered: Break memo to two columns

    I have one big memo field, which I would like show on web page in two columns.

    How to separate (split) this one memo field into two fields,
    String1 and String2.

    I would like to split it at my special word, let's say <break>.
    When my formula finds <break> word everything before this word move to String1, and everything else move to String2.

    Any suggestions, or maybe someone else do that before?

    Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    Atlanta, GA
    Posts
    191

    Re: Break memo to two columns

    strSplit=Split(rs("bigmemo"),"<break>")

    then, strSplit(0) contains all the text up to the break... and strSplit(2) contains everything after it.

    Tim
    Tim

Posting Permissions

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