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.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
So I'm not that great at RegEx to be honest. So here's what I'm trying to do. I have the video description for every youtube video for a channel
Description Example: http://theneedledrop.com http://twitter.com/theneedledrop http://facebook.com/theneedledrop http://theneedledrop.com/support http://theneedledrop.com/category/pod... http://theneedledrop.com/forum FAV TRACKS: RARE CHANDELIERS, THE SYMBOL, SYLVESTER LUNDGREN, DEMOLITION MAN, EGGS ON THE THIRD FLOOR, MODERN DAY REVELATION LEAST FAV TRACK: DENNIS HASKINS ACTION BRONSON AND THE ALCHEMIST / VICE / 2012 / HARDCORE HIP HOP, EAST COAST HIP HOP 8/10 http://www.theneedledrop.com/loved-li... Y'all know this is just my opinion, right?
What I want is the 8 from the last line. Each of his videos has a score for the album. I need a way to extract the score.
Go to Solution.
Go to Solution.
Is this 1 record or 3 records ?
I wouldn't use a RegEx, I'd use a SubString() and finding the location of "/10" like this:
This will return the 1 character before the "/10" in the field provided.
Using the parse method (with the RegEx tool), I'd do this:
This might be more specific to your needs.
I would recommend a RegEx solution. It isn't the easiest tool to learn but it can be configured to be very precise.
I'd use a formula tool, with the following expression:
This isolates the number before the "/10" in the rating, inclusive of 0-10 for all possible ratings
You can modify the existing field with the data, or create a new one. Cheers!!