• Hello friends

    I was wondering if anybody knows how to extract a spec report with spec name included in SPCO'S name.
    I mean for

    NEW SPECIFICATION /1BS2
    TEXT 'PIPING'
    HEADING
    TYPE       NAME     PBOR1 PBOR2 PBOR3 SHOP STYP  CATREF DETAIL MATXT CMPREF BLTREF TMPREF  PRTREF
    DEFAULTS
      -           -        -       -       -   TRUE  RC
    REDU   *-REDU-RCS-ACA9A1 80.00 40.00 0.00 TRUE  RCS  /MBRDPX00ACA9A1 /MBRDPX00-D =0 /W-DR00000JD0000-ACA9 =0 =0 =0
    REDU   *-REDU-RES-ACA9A1 80.00 40.00 0.00 TRUE  RES  /MBRFPX00ACA9A1 /MBRFPX00-D =0 /W-DQ00000JZ0000-ACA9 =0 =0 =0

    instead of this i want

    REDU   /1BS2-REDU-RCS-ACA9A1 80.00 40.00 0.00 TRUE  RCS  /MBRDPX00ACA9A1 /MBRDPX00-D =0 /W-DR00000JD0000-ACA9 =0 =0 =0
    REDU   /1BS2-REDU-RES-ACA9A1 80.00 40.00 0.00 TRUE  RES  /MBRFPX00ACA9A1 /MBRFPX00-D =0 /W-DQ00000JZ0000-ACA9 =0 =0 =0

    i use the format ---->  FILE /C:\TEST.TXT   --->  OUT NEW /1BS2 TERM

    REGARDS
    Harish
  • @h3nik ..thank you ..but That is not my purpose
    @me_hungry..   i want to extract a collective report of all spec.. so thats a master file of all specs, i receive catalogue request from different sattelites and many components already exists..
    so from a master file .. i have all the tag no's. i can directly check in the notepad and see catref boltref, detref are according to request ..without going to paragon or specon everytime
    somtime i receive tag no's (of special components ) without the knowldege of which spec they belong.. so such a master file is very handy for handling catalogue requests..

    Your help will be greatly appreciated
  • It seems not possible through Specon module. Instead, you should try updating text file with Dos batch method.
    Create a batchfile.

    @echo off
    Set flname=c:\xxx.txt
    FOR /F "tokens=3* delims= " %%a IN ('findstr /c:"NEW SPECIFICATION "  %flname%') DO set "REPL=%%a"
    set /a cnt=0
    rem Line Count
    for /f %%a in ('type "%flname%"^|find "" /v /c') do set /a cnt=%%a
    echo %flname% has %cnt% lines
    REM Read line by line and Update new text file

    setLocal EnableDelayedExpansion

    for /f "tokens=* delims= " %%a in (flname) do (
    set /a n+=1
    set v!n!=%%a
    echo.REPL v!n! >>newflname.txt
    )
    endlocal
  • Or you can create a Report using Utilities--> Reports --> Create , and give the correct expressions in the columns.
    Once you create that,you can save that Report template for future use for other specs.
    Can create both text & excel format, which should help you in your checking.
  • You can get a list of SPCOs [with most of the information that comes in spec output] from paragon using standard reporter.
  • @[COLOR=#417394]suren_bin   that is quite tricky and quite scary dos commands for me [/COLOR][COLOR=#3E3E3E][/COLOR]:05.18-flustered:...but surely i will try..:)

    @ [COLOR=#417394]Shrivallabha    i know that i can use standard reporter, but i guess we wont be able to get pbor1,pbore2 ,3 and angle ,radius information, we only get catref,matref,bltref etc info which are standard attributes of spco.
    Anyways I suppose there is no way to help it. Thank you very much forum members.[/COLOR][COLOR=#3E3E3E][/COLOR]
  • 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.
  • 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]

    It can be realise with help of c# too.