Field calculator error 999999

PeterCeelen — Mon, 28 Jan 2013 09:18:00 GMT

Arcmap 10.1

I have a vb script to creat a hyperlink in a new column.
In Arcmap 9.3 this script works perfect.
But in 10.1 i get a error.

Field [FOTO] holds the values of a photonumber (example 105-2087).
Script Code:

dim naam as string
dim v as variant

naam = [FOTO]

if naam = "" or naam = " " or isempty(naam) then
naam = ""
else
v = split(naam,"/")
naam = v(0)
naam = "Fotos\Foto_2012\p"&replace(naam,"-" ,"")&".jpg"
end if

The result window gives error 999999.

Are there any surgesties the solve the error.
Or is there a new kind of script that i can use to get a photo numer from one column to an other with txt infront and behind
example: column photo input: 105-0285
column photo_hyp output: photo\1050285.jpg

thanks,

Re: Field calculator error 999999

norie — Sun, 12 Dec 2021 02:57:06 GMT

You can try doing it in python:

In Codeblock:

import re 
def toFileName(fname):
 output = re.sub(r'[^0-9]', '',fname)
 if output:
  return 'photo\\' + output + '.jpg'
 else:
  return ''

PHOTO_HYP=

toFileName(!FOTO!)

topic Re: Field calculator error 999999 in ArcGIS Explorer Desktop Questions

Field calculator error 999999

Re: Field calculator error 999999