setting LK array values from text strings

For example, after using the inputs browser in SAM to export values to CSV we have utility PBI as follows

pbi_uti_amount

Utility PBI amount

10;11;12;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0

We can read that back into LK as a string

pbi_uti_amount = "10;11;12;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0";

I am looking for a code snippet that will take this string, parse it and set the array value in SAM

sam_set_inputs('pbi_uti_amount', arr).
I'm looking for a code snippet that can initialize arr from values in pbi_uti_amount.
Any help greatly appreciated!

Hi Kaiyer,

The PBI amount and other inputs that appear in the SAM user interface with the "Sched/Value" blue and grey buttons are arrays. If the array has one element, SAM interprets the value as a Year 1 value and applies inflation to calculate values in Years 2 and later. If the array has more than one element, it treats each value as a nominal value in each year. If the array is longer than the analysis period, SAM truncates the array length to the analysis period. If the array is shorter than the analysis period, SAM assigns the value zero to years with no values.

Here is some LK code that reads the string you provided, converts  to an array and assigns the array's value to pbi_uti_amount. It also runs a simulation and shows the PBI amount from the resulting cashflow so you can verify that it works:


Best regards,
Paul.