Recent content by trafford69

  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, Thanks all for their help especially bulkodd and casper.My program works very well. Thanks.
  4. T

    date format TODAY to DDMMMYY

    Hi bulklodd, my good friend , thanks again. It works but i have a question. I want to see date as 06OCT05, after printing i can see only 6OCT05 the "0" is missing. PLease help.Many Thanks.
  5. T

    date format TODAY to DDMMMYY

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

    Trailing Spaces or Zeros

    Thanks bulklodd, it worked like a charm. Much appreciated.Many Thanks.
  7. T

    Trailing Spaces or Zeros

    I need to pad with a space if the string is 1 digit (eg. 1^) and pad with spaces if the string is blank with just spaces (eg. ^^). Thanks.
  8. 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:
See more
Top