Onother method can be with PML(its not soo pretty):
-- By me_hungry
-- Date 06_07_13
!currentitem = !!ce
-- values inside not processed file
!readarray = object ARRAY()
-- file dir
!fileelement = object FILE('d:\OutputSpecs.txt')
!fileelement.DeleteFile()
var !spearr coll all spec with(matchwild(name,'*LIMBOSPEC*') ne true) for ce
speconmode
-- formate
do !specs values !spearr
$!specs
-- create file
file /$!fileelement append output ce file end
-- replace /* in file
!readarray = !fileelement.readFile()
-- values inside new file
!valinnewfile = object ARRAY()
do !readval values !readarray
!readval = !readval.replace('*/',!specs.dbref().name + '/')
!valinnewfile.append(!readval)
enddo
!fileelement.writeFile('OVERWRITE', !valinnewfile)
enddo
exit
$!currentitem
@Shrivallabha[COLOR=#3E3E3E][/COLOR]
[COLOR=#333333]Where will you be keeping your spec information, certainly not in txt files? Excel or Access? Then you could use bit of VBA to get column wise data. It will help after this project as well.[/COLOR]
Onother method can be with PML(its not soo pretty):
-- By me_hungry
-- Date 06_07_13
!currentitem = !!ce
-- values inside not processed file
!readarray = object ARRAY()
-- file dir
!fileelement = object FILE('d:\OutputSpecs.txt')
!fileelement.DeleteFile()
var !spearr coll all spec with(matchwild(name,'*LIMBOSPEC*') ne true) for ce
speconmode
-- formate
do !specs values !spearr
$!specs
-- create file
file /$!fileelement append output ce file end
-- replace /* in file
!readarray = !fileelement.readFile()
-- values inside new file
!valinnewfile = object ARRAY()
do !readval values !readarray
!readval = !readval.replace('*/',!specs.dbref().name + '/')
!valinnewfile.append(!readval)
enddo
!fileelement.writeFile('OVERWRITE', !valinnewfile)
enddo
exit
$!currentitem
@Shrivallabha[COLOR=#3E3E3E][/COLOR]
[COLOR=#333333]Where will you be keeping your spec information, certainly not in txt files? Excel or Access? Then you could use bit of VBA to get column wise data. It will help after this project as well.[/COLOR]
