Session 1: Field Transform Replace
Lesson 7 – Function Replace – CharSetsNot

Online Course Thumbnail

What will you learn:

  • Excluding character sets (charsetsnot) in the Integrator

  • Fixing typos by excluding certain characters

  • Using RegularExpressions to cleanse data


Welcome to the Jedox Integrator course, an add-on course designed to cover the Professional and Expert-level curriculum (300 and 400-level courses) as outlined by the Jedox Academy. Here you will learn how to use Jedox for your company’s business intelligence and corporate performance management needs with guidance provided by the Head of Academy, Thomas Arampatzis, and Online Education Consultant, Sabrina Sebens.

In this lesson, you’ll learn how to transform your data by using Regular Expressions in the Integrator. This example shows how to fix typos when you don’t know what exactly the typo is by excluding the correct characters from you set, thus using charsetsnot.

  • Course Type

    Jedox Integrator

  • Duration

    03:12 min
  • Language


  • Speaker

    Thomas Arampatzis
    Sabrina Sebens

Learn More

Get familiar with Jedox as a platform by watching our Platform Basics course, where you can learn how to create ad-hoc reports, customized reports, and set up data models among other things. Don’t forget that you can try out Jedox for yourself for free with a 14-day Cloud trial or for 30 days with a standard trial, and check out the Jedox Blog for some great practical examples and our user documentation resource at the Jedox Knowledge Base.

Back to Overview