Extract and Generate table with one word per record

[qslx101]

Extract and Generate table with one word per record

Hello!
I need help!

Table A is populated with frases in each record. I wish to generate table B with all words from table A, but each word must be inserted in new line of table B. This should be done for all records of table A.

Is there a way to do that ?

I appreciate any help. Thank you very much.

Qslx

 

[IMFCSDMN]

Could you map out what your tables look like? columns? rows?

 

[MichaelRed]

A 'strange' request, but not all that hard.

The first table (with multiple words per record) can be instantiated as a TableDef, which can be used to return the records and fields (and even field types).

So, a new table can be created (either manually or by code). It should (presumably) have only a single field (text) of some reasonable length (say 35?)

Then, a couple of loops would cycle through each field of each record of the original table (TableDef) and parse (split) each field into individual words. Then just use add each "word" as a new record to the new table.

Of course, the devil is (as usual) in the details -which will vary depending on which version of what libraries and references you are most comfortable with. Since you have not provided this, the 'advice' is necessarily limited to thses generalities.

See the ubiquitous {F1} (a.k.a. Help) for at least some thoughts on the terms which are in BOLD.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places