I have a query which returns user security settings for specific applications within our bigger app.
The people who setup the table made all of the security settings fit into one field rather than defining the individual fields so I wind up with a blob that looks like this:
NNYYNYNN NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNYNNNNY
Each of those correspond to individual settings. I know how to use string slicing, to get individual fields.
What I would like to know is if I return this blob, is there a way to get say the 15, 25, and 48 characters? I could also setup queries to do substr() and get the characters I want, I am just wondering if there is a python way to do this. I would prefer to not have to setup multiple queries since the variations are literally endless, for the example above which is one of about 20 different applications I have to work with.
sis accessed ass[14]. Is that not what you want?