I need someone to program an application which will take a spreadsheet containing roots, prefixes, suffixes and create words by concatenating together the roots,prefixes,suffixes in the first columns.
The spreadsheet columns look like:
[code]
Root, Prefix or Suffix Meaning Examples
a, ac, ad, af, ag, al, an, ap, as, at to, toward, near, in addition to, by aside, accompany, adjust, aggression, allocate, annihilate, affix, associate, attend, adverb
ab, abs away from, off absolve, abrupt, absent
act, ag do, act, drive active, react, agent, active, agitate
acu sharp acute, acupuncture, accurate
-acy, -cy Noun: state or quality privacy, nfancy, adequacy, intimacy, supremacy
-ade act, product, sweet drink blockade, lemonade
ag, agi, ig, act do, move, go agent, agenda, agitate, navigate, ambiguous, action
-age Noun: activity, or result of action courage, suffrage, shrinkage, tonnage
[/code]
The first column contains multiple prefixes/roots separated by "," so the application need to take that in consideration. What starts with "-" is a suffix so must be always positioned in the end. What ends with "-" can only be a prefix, so it can only be used at the start of a word. The rest can be prefixes or roots (so the word can start with them, or have them in the middle - calling them just roots for now).
The application should be able to concatenate up to three together, example:
root + root
prefix + root
root + suffix
root + root + suffix
prefix + root + suffix
the application should create a csv/excel spreadsheet which contains all combinations, and the meanings of the parts composing the word. So the columns should look as:
New Word, First Part, Second Part, Third Part
"performance","through, intensive","shape or resemble","Noun: action, state, quality or process"