Aluminum | High-performance , GPU-aware communication library | GPU library

You can use your own datasource like below

a. This is your custom datasource that you defined.

If I understand your Question correctly then you need to use onPanelSlide: callback to report the sliding percentage of your panel.

so in your SlidingUpPannel will be

As I wrote so many comments I decided to post a guide answer and delete my comments i.e. provide some pointers to one possible solution.

Logic:

I would read everything into an array and loop the rows of that. Apply logic that processes rows according to rules e.g. does it start with Section..... is it a Capital letter at start of col 1 of array... is it a number...

A nice idea is probably to use helper functions. E.g.

• A helper function which grabs the lines upper case after Section down to next upper case (stop before) and returns that text (as an array).
• Then pass that function return value to another function which handles the alphanumeric based indentation levels (using appropriate Chr$()) etc
• Another function call to concatenate those values into single string - which will be the value associated with a given key.
• Then update the dictionary with the key value pair.

This way you can create a dictionary of key A: associated text from last of helper function calls and write out to sheet at end.

You will need additional logic for tables etc. Tables would be added to dictionary as an array with key being value from first column

At the end you can loop and write out to sheet. I think caution is needed with writing out tables as they may take more than one row. In that case, have an additional helper function that calculates last populated row anywhere in sheet (or target column range) and ensure next key:value pair is written out to after the table by adding + 1 to last populated row number.

When you write out the table, you will need to test the dictionary key for it containing 'table', or that its value is an array; you will need to resize the target cell to the size of the array e.g. if dict(key) = results then targetCell.Resize(UBound(results, 1), UBound(results, 2)) = results

Think about how any hyperlinks (where friendly name different from destination)| additional metadata will be passed around.

Supplying sample data:

I think I would suggest you use a markdown table generator to supply the current data (the input data) to save people time having to write out their own data. You can paste from Excel into markdown generator, press generate table, then copy to clipboard that table, use edit to insert into question. Highlight table just pasted in and press Ctrl + K to indent properly.

Regex:

Regex is not required from what I can see. Data resides in separate cells in source.

Tagging:

I think remove the python tag unless you have python code to add.

Resources:

1. https://bettersolutions.com/vba/strings-characters/builtin-constants.htm

Some useful constants regarding indentation

Use min()?

The original problem was caused by a spurious comma after input$Fe. This then led to a second problem caused by the mismatch between the names of the test dataframe required by the code and the construction of this from the input values. I also needed add a call to library(caret) when building the model. It runs now and I can see that Type is being passed into the prediction call. Not sure why this is needed since the prediction is trying to come up with the Type, so I removed that. I also removed the creation of the input.csv file and just created the test data frame directly.

Here is the full app.R.

You will need to keep the prices and names together during the sort operation. This can be achieved by combining them in a list of tuples (starting with the price) that you sort and then assign back to the dictionary items:

If we assume subcategories stored in each object,

EDIT: I just realized you're reading a line at a time...The second code sample demonstrates that.

Start by splitting the string into lines on "\n" Then split each line on a comma Save the first row as headers and the rest as lines fields

For every row:

1. create a new empty object
2. iterate over each field and place the key:value pair in the result array

result[idx][headers[headerIdx]] - uses the row index for the array index and the header index to provide the key. The assigning the field value to that yields:

'[{table:"SF1", permaticker:196290,` .... etc.

This can easily be done with grep