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.
HI
I have been extracting the data from sharepoint office 365 to power bi, here am facing one issue while extracting data from text. Could you please help me, how to extract the highlighted data into one new column.
Kindly refer the below screenshot.
Regards,
Yuvaraj
Solved! Go to Solution.
HI @Anonymous,
You can try to use following formula to extract specific characters from other column:
Comment = VAR _left = FIND ( "<p>", [Element], 1, -1 ) VAR result = MID ( [Element], _left + 3, LEN ( [Element] ) - _left ) RETURN LEFT ( result, FIND ( "<", result, 1, -1 ) - 1 )
Regards,
Xiaoxin Sheng
HI @Anonymous,
You can try to use following formula to extract specific characters from other column:
Comment = VAR _left = FIND ( "<p>", [Element], 1, -1 ) VAR result = MID ( [Element], _left + 3, LEN ( [Element] ) - _left ) RETURN LEFT ( result, FIND ( "<", result, 1, -1 ) - 1 )
Regards,
Xiaoxin Sheng
Hi
Thanks for your reply its working fine but for few rows its not as expected due to that delimeter range has been different for every row. Could you please provide any possibile solution to acheive this.
Regards
Yuvaraj
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |