locked
String manipulation in a vocabulary RRS feed

  • Question

  • User1849780110 posted

    Hello,

    I have a very old vocalary as a text file and I would like to import it to a Access-Database table with two columns: 1)word 2) explanation. The word separation sign is #.
    It looks like so:

    #tree#
    It has many leafs and so on...

    #sun#
    it gives us a lot of energy and so on

    I could not manage to import the text. The explanations are very long, till 2000 chars. I suppose that it should be necessary to manipulate the text first to prepare it for the import. 

    Please help me!

    Krsnic

    Friday, May 1, 2020 7:34 AM

All replies

  • User288213138 posted

    Hi krsnic,

    I have a very old vocalary as a text file and I would like to import it to a Access-Database table with two columns: 1)word 2) explanation. The word separation sign is #.
    It looks like so:

    #tree#
    It has many leafs and so on...

    #sun#
    it gives us a lot of energy and so on

    I could not manage to import the text. The explanations are very long, till 2000 chars. I suppose that it should be necessary to manipulate the text first to prepare it for the import. 

    You can set the type of the explanation field in your database to Long Text data type.

    The Long Text type up to about 1 GB, but controls to display a long text are limited to the first 64,000 characters.

    More information about Long Text type you can refer to this link:

    https://support.microsoft.com/en-us/office/the-memo-data-type-is-now-called-long-text-dffe5e34-953e-4451-a05e-fba5d9b564b5

    Best regards,

    Sam

    Monday, May 4, 2020 1:55 AM
  • User1849780110 posted

    Thanks, Sam.

    I think, I did not explain well the problem. I cannot manage to extract the word separated with separation sign "#" from the following text (explanation). Wenn I try it, I get many fields instead of only two. I show an extract of the original text.

    #abandonniren#

    von Seiten des Versicherten dem Versicherer ein verunglücktes oder vom

    Feinde genommenes Schiff gegen einen gewissen Prozentsatz der

    Versicherungssumme zu überlassen.

    #abgewinnen.#

    Es gilt für ein Zeichen besonderer seemännischer Tüchtigkeit, wenn es

    dem Kapitän eines Schiffes gelingt, einem anderen die Luv oder den Wind

    abzugewinnen, d. h. sein Schiff so geschickt zu führen, daß es näher,

    höher, dichter an den Wind kommt als das andere. 

    #abhalten#

    1. so segeln, dass das Schiff, das beim Winde segelt, raumeren (s. d.)

    Wind erhält, also »die Richtung des Schiffes dergestalt ändern, daß der

    Wind, welcher vorher auf das Vorderteil oder die Seite desselben

    gerichtet war, mehr von hinten in die Segel fällt«

    Thank you!

    Monday, May 25, 2020 10:42 AM