Skip to Content

trim left zero

Hi.

How to transform '00001266' into '1266' in table view?

Thx

Vlad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 05, 2010 at 06:43 AM

    Hi

    Are you using BI query? If yes, right click on the query & go to define test query option. For each characteristic you will see 3 options - Text,Key & Ext Key. You just check Key or Ext Key. Ext Key will show you the required result for the same field. Make sure you have set display properties in the query as 'Key & Text'.

    If you still have any doubt then let me know.

    Regards

    Sandeep

    Add comment
    10|10000 characters needed characters exceeded