Search results

  1. T

    how to truncate to the left

    how do i substr/truncate to the left if more than 9 characters in progress
  2. T

    remove/trim spaces

    Hi, I have a problem. How do i remove/trim spaces in progress? example if my data vary between 6 or 7 characters. Any samples? Thanks.:)
  3. T

    date format TODAY to DDMMMYY

    Hi guys, Can someone show me how to format date(TODAY) to DDMMMYY (eg. 26MAR05 )? Thanks. :)
  4. T

    Trailing Spaces or Zeros

    Hi All, How do i add a trailing/behind space/zeros to a field in progress? Here is a sample i did to add zeros in start/beginning. STRING(FILL(" ",2 - LENGTH(TRIM(SUBSTR(ID00_RESERVED,12,2))))) Thanks.:biggrin:
Top