Hi there,
I am banging my head on this. I have 12 columns and I need to loop through these columns and do some string manipulation (extract a string in the respective column rows), then append the extracted string into a new column.
So using Column List Loop node, I can select the columns to read, and end the loop with column append node adds the new column. The string manipulation part I need to write in the javascript node (as the string extraction is complex), but I cannot see how I pass the column name into the javascript node.
Can you help,
Thanks,
Stanage
The use case is I am extracting an atom count value from a chemical structure represented as a .mol string, The string has the form;
- id1234556 \n\n 30 32 0 0 0 0 0 1 v2000\n
so I need to extract from the above example the number 30 (this represents the atom count within the .mol file format), the identifiers I am using for the string are;
start position â\n\nâ
end position v2000\n
I can then parse the numbers into an array to extract the diifferent values as needed.
Happy to consider any approach though or any suggestions.