Extract a value based on record order 1

[griffter]

Hi all. Hope you can help me again. I have a field which holds a string of ratio value say 2:2:1:2, this is represented as a string value.

What this relates to is the ratio that should be applied for each record. So I will have 4 records in my selection. I need to compile a formula that will enable me to display an individual ratio value for each record:-

First item in string is 2 so for my first record I need to display in a field 2, second item in the string is 2 so for my second record I need to display in a field 2 my third item in the list is 1 so I need to display in a field 1 and my last value in the list is 2 so I need to display in a field 2.

Any help in composing this formula would be greatly appreciated.

Di

 

[GJParker]

Try something like this

Split({MyTable.Field},":")[RecordNumber]

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[griffter]

Thanks Gary, you saved me a lot of work trying to figure this out, it worked a treat!!!