Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

TRIM Trailing Not Working

Received Response
11
Views
1
Comments
Tonya H
Tonya H Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Forum

Hello:

I have a column that I want to remove all characters after { and it isn't removing any characters. It is not erroring out, but shows the entire column.

Here is my formula:

TRIM(TRAILING '{' FROM "Opportunity"."Opportunity Name")

What am I doing wrong?

Thanks for any insight.

Tagged:

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics & AI Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/20139/trim-trailing-not-working

    Hi @Tonya H,

    Welcome to the Oracle Analytics Community.

    Please find below the definition of TrimTrailing function and a working example, it might help to understand the working methodology.

    TrimTrailing‎ function Strips specified trailing characters from a character string.

    Example:

    Used the following to Trim Trailing 6.

    TRIM(TRAILING '6' FROM "Worker"."Employee Mailing Address Line1")
    image.png

    If you want to remove any character after '{' then Trim Trailing is not the correct function to use.

    Here's a high level steps that needed to be done:

    1. Identify the total length of the string.
    2. Identify the Position where '{' is occurring.
    3. Take the characters till to the number returned by Step2 from the total length return by Step1 from the beginning using SubString function.

    Hope this help.

    Thank You!