Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All -
I am currently working with some Google Analytics data and attempting to extract out a specific piece of text from the URL column into another column.
The urls are typically formatted as:
website.com/ua/acct_pr/acs/cs_us_en/bulletins/ubs.htm?Product=acs&FirmID=324270&mybanner=1
I would like to specifically pull out the number after the FirmID=.
The tricky part is, it doesn't occur at the same spot in the string in order to count characters. I tried to split the column with the & as the delimiter, but no such luck as it occurs in some of the rows for various reasons.
I am not the most seasoned programmer by any means, so any help would be greatly appreciated.
Solved! Go to Solution.
@Anonymous If number after FirmID= is always going to be of six characters then below will do the trick. Under modelling tab create new calculated column as below.
NewColumn = MID(TABLE[URLColumn], FIND("FirmID=", TABLE[URLColumn] ) + 7, 6)
@Anonymous If number after FirmID= is always going to be of six characters then below will do the trick. Under modelling tab create new calculated column as below.
NewColumn = MID(TABLE[URLColumn], FIND("FirmID=", TABLE[URLColumn] ) + 7, 6)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |