31
Utility Programs

June 2010 - G. Buccellati
[August 2022 - M. De Pietri]
A Digital Monograph
The home for this page is GRAMMAR

31.1 UFL: splits files within files by file label
31.2 UINS: inserts data in blank fields of TP files
     31.2.1 Input
     31.2.2 Operations
     31.2.3 Output
31.3 UOJ: creates J-files from O output
31.4 UJXCL: creates EXCEL file from .J files
31.5 URPL: replaces one string for another within a given folder
31.6 UTPD: checks Exel TP files for duplicate sherd numbers
31.7 UTPF: fills in number 70 for cp if blank

31.1     UFL: splits files within files by file label

Back to top

31.2     UINS: inserts data in blank fields of TP files

Back to top

     31.2.1     Input

for shape sherds

.rd

 

.ri

 

.bk

 

q#

 

cp

 

F2

 

wm

 

sh

 

ZcaS1

 

ZcaS2

 

ZcaS3

 

ZcaS4

 

ZcaD1

 

ZcaD2

 

qc

 

w1

P801

 

HH

 

A16

 

730

 

1

 

281

 

P

 

j

 

h

   

5

     

2

  

CH

 

k

 

b

 

c

 

s3

         

18

     

3

  

RC

 

j

 

n

 

f

 

2

         

10

     

4

  

CH

       

f

for body sherds

.rd

 

.ri

 

.bk

 

q#

 

cp

 

f

 

wm

 

sh

 

ZcaD1

 

ZcaD2

 

qc

P808

 

JM

 

A16

 

457

 

70

 

177

 

CH

       

35

        

71

   

RC

       

4

        

72

   

P

       

2

        

73

   

CH

   

k

 

4

 

2

Back to top

     31.2.2     Operations

Back to top

     31.2.3     Output

fields added are underscored
for shape sherds

.rd

 

.ri

 

.bk

 

q#

 

cp

 

F2

 

wm

 

sh

 

ZcaS1

 

ZcaS2

 

ZcaS3

 

ZcaS4

 

ZcaD1

 

ZcaD2

 

qc

 

w1

P801

 

HH

 

A16

 

730

 

1

 

281

 

P

 

j

 

h

   

5

         

1

P801

 

HH

 

A16

 

730

 

2

 

281

 

CH

 

k

 

b

 

c

 

s3

         

1

 

18

P801

 

HH

 

A16

 

730

 

3

 

281

 

RC

 

j

 

n

 

f

 

2

         

1

 

10

P801

 

HH

 

A16

 

730

 

4

 

281

 

CH

         

f

       

1

for body sherds

.rd

 

.ri

 

.bk

 

q#

 

cp

 

f

 

wm

 

sh

 

ZcaD1

 

ZcaD2

 

qc

P808

 

JM

 

A16

 

457

 

70

 

177

 

CH

       

35

P880

 

JM

 

A16

 

457

 

71

 

177

 

CH

       

4

P880

 

JM

 

A16

 

457

 

72

 

177

 

P

       

2

P880

 

JM

 

A16

 

457

 

73

 

177

 

CH

   

k

 

4

 

2

Back to top

31.3     UOJ: creates J-files from O output

Back to top

31.4     UJXCL: creates EXCEL file from .J files

Back to top

31.5     URPL: replaces one string for another within a given folder

Back to top

31.6     UTPD: checks Exel TP files for duplicate sherd numbers

Back to top

31.7     UTPF: fills in number 70 for cp if blank

Back to top