Skip to Content
author's profile photo Former Member
Former Member

Triming Leading Zeroes

Hi,

We have a query which uses a variant to accept a value for a field by the name of Internal Order. In our Cube the data for this field is stored with leading Zeroes e.g. '0002000'.

When the user enters the value for this variant without the leading zeroes e.g. 2000 instead of 0002000 then the query does not return any output. But if the leading zeroes are entered then the query returns the results.

How do we trim the leading zeroes while checking from the field in the cube.

One more thing the query does not return any error while executing if leading zeroes are not entered.

Thanks & Regards

Raj

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 04:35 PM

    Hi,

    you can try to change the field definition to number, because in an number field you don't have to type the leading zeros .

    ( I assume you defined the field as character, because in an char field you have to type the leading zeros.)

    Reguards

    Sebastian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I would recommend using ALPHA conversion also. Why delete something if you don't have to, it's dangerous. Plus, in your transfer rules, you can just check a box.

      If you need to code it, you can use function module 'CONVERSION_EXIT_ALPHA_INPUT'.

      Brian

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.