String manipulation in a vocabulary

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

Answer 1

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

Answer 2

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!