I have a some strings with numbers at the start, e.g.
And i'm trying to just extract the leading numbers, so the result for the above would look like;
I believe 1 way of doing this would be to use the RegEx tool, but it seems like I can achieve the same output by just changing the data type of the field from string to double using the select tool.
I was just wondering whether this is a reliable way of performing this operation? Or whether the Alteryx implementation of the data conversion could throw up issues in some cases?
Also, is there a repository where things like this are documented? I did try googling, but it seems there's only really documentation of how functions/tools operate on a higher level, not so much the "nuts and bolts" of the implementation.
I'd processed the data prior to this point, so it was in a position where i just wanted the first number and then everything else dropped, but i appreciate what you're saying.
Apologies, when i said "simpler and quicker", I should have just said simpler - I haven't actually done a performance comparison. I'm still just getting to grips with Alteryx, but will compare the 2 methods when I start working with enough data where runtime becomes an issue.
I guess in terms of being sure about the actual behavior of the implementation, that's something that's documented anywhere?