You need to write a script or three.
Each script operates on the combined field, looking for some part of it, and then uses that to set the value for the other fields.
Example, you have a field called powertype which contains something to the effect of “Cleric Attack 1” and want to use that to fill fields called class, type, and level with the values “Cleric,” “Attack,” and “1” respectively. The script then needs to differentiate the different parts of card.powertype. There are two ways to do this:
1) You can use a series of if contains(string,match) statements. This has the advantage of not caring about the exact order of entry or even whether all the elements are present. The disadvantage is that you would need to be updated each time a new class or power type was added and you would have to check the list order for substrings, making sure that the more long string is matched before the string that it contains. For example, the part of the script that fills the level field might look like this:
if contains(card.powertype,match:"30") then card.level = 30
else if contains(card.powertype,match:"29") then card.level = 29
else if contains(card.powertype,match:"28") then card.level = 28
...
The reverse order serves to keep 30 from matching 3 (as to get to 3, we’ve already decided the string doesn’t contain 30).
2) You can use the break_text and regular expressions to break the string up into a list of substrings and then use that list to fill the fields. The advantage is that this wouldn’t require updating. The disadvantage is that field contents have to match the right format or the function won’t work. For example, if the regular expression was keyed to break on spaces, then all classes and power types would have to be single words (which is the case so far). For example:
break_text(card.powertype,match:"[^ ]+")
should break “Cleric Attack 1” into ["Cleric”,"Attack”,"1"]
I should note that I’m not real familiar with regular expressions, so I don’t know for sure how this would be implemented. I’d have to play with it to get it just right.