Folks,
I have a column c1 that has entries like "GXP_297346(PVALB/human)". I'm trying to use Text Manipulation > Compute to strip off the "(...)" portion, leaving only the accession (which can vary in length).
I have tried a variety of things that work in my python command line, but fail here, for example: c1[1:c1.find("(")] or c1.split('(')[0]
This gets mangled: An error occurred running this job: Expression "c1__ob__1:c1.find("(")__cb__" likely invalid. Or An error occurred running this job: Expression "c1.split("(")__ob__0__cb__" likely invalid.
Please help. This is driving me crazy. Searching the list, I find only http://gmod.827538.n3.nabble.com/inputs-sanitization-tt2664336.html#a2664911 "Inputs sanitization" which seems to indicate this is a global mapper that can only be disabled with dire security consequences. And http://gmod.827538.n3.nabble.com/substring-sequence-on-coordinate-in-columns... "substring sequence on coordinate in columns" which doesn't ever answer the question about how to get compute to work.
Thanks, Curtis