Hi. Does anyone know of a way to read whole text file in as a single string cell, without any modification to the text - no space-stripping, no changes to return characters etc - which also allows me to read in from cloud storage via a file system connection port? I have tried using the File Reader node and setting row and column delimiters to wird characters that aren’t in the data, and turned off anythig that looks like a stripping option, but it’s still dropping a “\n” and a few spaces at the start of the file, which corrupts the data.
In case anyone is thinking “why would you want to do that?”, the answer is I don’t. I really want to read an SDF file from cloud storage, but the chemistry IO nodes still don’t support file system ports. This is just a work around to read the text in and then have an Python+RDKit snippet do the parsing.
Unfortunately none of those posts help here. None of the suggested nodes support file system connections, so they can’t read directly from cloud storage.
Hi @rsherhod , my apologies that I didn’t pick up on the Cloud storage part. Would it be an option to transfer the required file from cloud to local storage first, e.g. using the Transfer Files node, and then use one of the methods suggested for opening the local copy?
btw I only just saw your reply by chance as you hadn’t tagged me and I didn’t get alerted to your response. Probably best to always tag when replying in a conversation, just in case
