Import a Note with Returns

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
  • October 16, 2011 at 3:32 PM #3512

    Pucki
    Participant

    I have a Note-Field in mein Windows Database. If ein make a SDF-File to Import it in TAP-Forms HD i have a Little Problem.

    The Note-Field have a Return-code (chr$(13) in the Text to switch the line in the Field.

    for example, the contents of the memo field :

    ‘ Text one and a Return

    text 2 and a Return

    Text 3 and a return ‘

    If i Import it to TAP-Forms HD it only import “text one” in the correct Note-Field and make 2 new datarecords this one as ‘text 2″ and the other as ‘text 3″

    What can i do.

    Thx for Help

    Pucki

    p.s: sorry for my bad english but i’m from Germany

    October 16, 2011 at 7:38 PM #4895

    Brendan
    Keymaster

    Hello Pucki,

    As long as your text with carriage returns in it has double-quotes around it, you should be good to go. It looks like you have single-quotes around your text. Make sure the import encoding matches the encoding of the file you’re importing too. That can make a big difference too.

    Thanks,

    Brendan

Viewing 1 reply thread

You must be logged in to reply to this topic.