Any Function to decode UTF-8 characters available in Domo?
Hi,
I have a URL field in my dataset where the data in certain rows have UTF-8 characters instead of normal html characters…
For example….
https://www.theverge.com/2024/11/26/24306815/google-gemini-spotify-extension-rollout-android
is showing up as
https%3A%2F%2Fwww.theverge.com%2F2024%2F11%2F26%2F24306815%2Fgoogle-gemini-spotify-extension-rollout-android
Is there any function in Magic ETL or Beast Mode that would allow us to decode this?
Best Answer
-
Hello @b_rad,
You can achieve this with a simple Python script. Here's the input:
The script:
Replace 'Domo Forum Answer 2' with the name of the tile preceding the Python Script tile and 'ID' with the column name in your dataset. The result will be:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1
Answers
-
Hello @b_rad,
You can achieve this with a simple Python script. Here's the input:
The script:
Replace 'Domo Forum Answer 2' with the name of the tile preceding the Python Script tile and 'ID' with the column name in your dataset. The result will be:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1 -
Wow!! That's amazing. Can you please post the actual script as a text? It'll be helpful as I am not a programmer.
0 -
Hi @b_rad
Here you go:
#Import the domomagic package into the scriptfrom domomagic import *
import pandas as pd
from urllib.parse import unquote#read data from inputs into a data frame
input1 = read_dataframe('Domo Forum Answer 2')
#write your script here
input1['ID'] = input1['ID'].apply(unquote)
#write a data frame so it's available to the next action
write_dataframe(input1)
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive