查看单个帖子
旧 2009-04-13, 12:35 PM   #1
yang686526
高级会员
 
注册日期: 06-11
帖子: 14579
精华: 1
现金: 224494 标准币
资产: 234494 标准币
yang686526 向着好的方向发展
默认 【转帖】macro code help

macro code help
if i use the code below to strip off the last 6 characters of a file name, what code would i use to capture and store the first two characters of the file name?
filename = strings.left(filename, len(filename) - 6) & "pdf"
my goal is to capture and store the first to characters and then us those characters to set the dir to save a file into.
thanks.
todd
check out our whitepaper library.
filename = strings.left(filename, (len(filename) - (len(filename) - 2)))
this will return the first two characters of the string "filename"
there is probably an easier way to do it, but it works.
strings.left(filename, n)
this just takes the first n characters from the left side of filename. so if you want to retrieve the first two letters of filename, use
strings.left(filename, 2)
strings.left(filename, (len(filename) - (len(filename) - 2))) will work, too. however, if you look closely it's really saying strings.left(filename, x - (x - 2)). x - (x - 2) = 2, so you're back to strings.left(filename, 2).
wow, do i feel dumb. math has always been my strong point, too.
thanks for the input guys! i can always count on this forum!
have a great weekend.
todd
yang686526离线中   回复时引用此帖
GDT自动化论坛(仅游客可见)