« Previous Next »

• 01-12-2008, 1:58 AM

  squadjot Joined on 12-29-2007, 7:48 PM Posts 5	can i create leading zeros? Reply Contact HI I need help to figure out how to add 2 leading zeros infront of some numbers i'm collecting with LP. 001 002 003 etc ... 054 055 056 etc (the numbers do not have leading zeros when they are being read, so -dtLines:0 wont help me) Does anyone have an example.. or just a little pointer where to look/begin?... Thx

• 01-17-2008, 12:15 AM

  In reply to

  Zhao Ji Ma - MSFT Joined on 01-05-2007, 5:36 AM Posts 765	Re: can i create leading zeros? Reply Contact Hi,  Try using STRCAT, like this: STRCAT( '0', numbers ) Zhao Ji Ma Sincerely, Microsoft Online Community Support “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”

• 01-17-2008, 9:20 AM

  In reply to

  squadjot Joined on 12-29-2007, 7:48 PM Posts 5	Re: can i create leading zeros? Reply Contact Yes, I know that, it was more how syntax-wise to make the IF statement.. i'm not sure how exactly to put it up. It must be something about asking how long the string is (of number), and accordingly adding needed zeros..   It's more like..  how? :)
  	Tags: W3C input format

• 01-18-2008, 1:15 AM

  In reply to

  Zhao Ji Ma - MSFT Joined on 01-05-2007, 5:36 AM Posts 765

  Re: can i create leading zeros? Reply Contact Hi, Based on my understanding, you can use strlen and where claus, for example: where strlen(field) = 4 Zhao Ji Ma Sincerely, Microsoft Online Community Support “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”

• 01-18-2008, 5:00 AM

  In reply to

  squadjot Joined on 12-29-2007, 7:48 PM Posts 5	Re: can i create leading zeros? Reply Contact I liked the old logparser forum better =(