Skip to content

    • Beast Mode

    Beast Mode

    Any Function to decode UTF-8 characters available in Domo?

    Contributor
    in Beast Mode

    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?

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Contributor
      Answer ✓

      Hello @b_rad,

      You can achieve this with a simple Python script. Here's the input:

      image.png

      The script:

      image.png

      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:

      image.png

      If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

    Answers

    • Contributor
      Answer ✓

      Hello @b_rad,

      You can achieve this with a simple Python script. Here's the input:

      image.png

      The script:

      image.png

      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:

      image.png

      If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

    • Contributor

      Wow!! That's amazing. Can you please post the actual script as a text? It'll be helpful as I am not a programmer.

    • Contributor

      Hi @b_rad

      Here you go:


      #Import the domomagic package into the script

      from 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.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories