This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?