task TASK question: How to use the contents of a field to select the contents of another field in the record? (Text->Fieldname)

[sfraden]

OK, so I need to make a task that will read in a text field in a record, process the text into individual parts (This much I can already do) and then use each part as a field name to get the actual data I need.

Example of a record:   

Field 'W1d1' contains text of "g1,g18,g47,g73"   I would separate the text into 4 vars, v1="g1", v2="g18", etc.

I then want to use the contents of v1 as a fieldname to get the contents of field 'g1'

Is this sort of conversion possible in a TASK?  I wish we could use arrays as fieldnames.....

SFraden

 

[NiceDuck]

Just to verify, do you mean that you want to distribute the content of the field w1d1 to the fields on the other table?

If we have a static amount of comma separated values on the w1d1, perhaps you can try using a variable to capture the initial value of the w1d1, then use some blocks to capture the content up to the first comma, save it to the first field, remove it on the string, capture the value up to the first string again, save it on the second field, and so on.

However, since you the intended to place those values on a separate fields, we cannot just loop it and you will have to manually create the field allocation for the whole task. 

 

The following are the blocks that may help you for this:

[sfraden]

On 12/29/2020 at 11:01 AM, NiceDuck said:

Just to verify, do you mean that you want to distribute the content of the field w1d1 to the fields on the other table?
 

Not exactly, the content of field w1d1 are the names of other fields, seperated by commas.  Pulling it out is not the issue, its using the pulled out names as a fieldname to act on that  is the issue.

clarify:  Field w1d1 contains "g1"  i need to use that entry to access field g1.  Field g1 actually contains the information i need.

[NiceDuck]

May I ask for a sample screenshot of your actual table and expected result? Im still confused on what you are trying to build

[sfraden]

8 hours ago, NiceDuck said:

May I ask for a sample screenshot of your actual table and expected result? Im still confused on what you are trying to build

Im trying to find a solution, the table is not made yet.  It's moot now, found out you cannot use the contents of a field as a fieldname....