I'm blocked with this problem for several days ...
I can extract a string from a XML file and I can put it into a field of a table, by using LOAD FROM file (XmlSimple, Table is ...).
Now, rather than inserting the string, I would like to insert each word of this string (words are separated by « ; ») into the table. And there, I am blocked.
I handle well functions like « subfields », « substringcount »… to extract each word but I do not know where to put the loop (« for » or « do while ») in order to load each word of the string into the table…
It seems working by simply removing the third parameter. thank you for the tip !
However each word is extracted "as is", even with the blank space just before the word. It would not be a problem if all words would be with this blank space, but the first word has no blank space which makes the ordering (ascendent for example) not working.
Would you know how to normalize the format of the words (ie without blank space) ?