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.
Can you help,
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.