Pad Middle of string with zeros
From: Ben (Ben_at_NoSpam.com)
Date: 02/28/05
- Next message: kd: "Re: Select Case and OrElse"
- Previous message: Andrew Sword [MVP]: "Re: Need Help programmatically setting AD Permissions"
- Next in thread: Diana Mueller: "Re: Pad Middle of string with zeros"
- Reply: Diana Mueller: "Re: Pad Middle of string with zeros"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Feb 2005 11:21:29 -0000
Hi
I have a string which is at least 4 characters but can be more which I need
to pad, with zeros, to a full length of 15 after the 3rd charactor.
Eg '1234' to '123000000000004'
How can I do this?
Also how can I truncate this back to 4 or however many charactors (e.g.
123000000000400 = 123400)
Any help will be much appreciated
Thanks
B
- Next message: kd: "Re: Select Case and OrElse"
- Previous message: Andrew Sword [MVP]: "Re: Need Help programmatically setting AD Permissions"
- Next in thread: Diana Mueller: "Re: Pad Middle of string with zeros"
- Reply: Diana Mueller: "Re: Pad Middle of string with zeros"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|