Tab delimited and tool libraries

[Bruce Caulley]

Good evening all,

I have no trouble reading a tool library into excell, but how do I go about saving it back to its original spacing format?

 

This is related to this topic

 

tool library

 

Thanks

Bruce

[Bruce Caulley]

Ok. I have removed the tabs by importing into word and replacing tabs with spaces. The text file that I get as a result looks good, but creates an empty library if I try and create library from text. Here it is:

code:

---

 # TOOL LIBRARY FORMAT - Mon Apr 4 19:24:15 2005     

# = comment if 1st character in line

# line 1 - TOOL (start of tool definition)

# line 2 - tool material "(1-HSS," "2-CARBIDE," 3-COATED "CAR," "4-CERAMIC," "5-BORZON," 10-UNKNOWN)

# line 3 - tool comment

# line 4 - tool name (geometry reference for backplot)

# line 5 - tool manufacturer

# line 6 - chuck designation

# line 7 - "tool_no," "tool_type," "rad_type," "dia," "crad," "thds," "tip_angle,"

# "dia_off," "len_off," "feed," "plunge," "retract," "rpm," "coolant," "n_flutes," "bottom_turret," station

# line 8 - Drilling attributes (see tool_type in line 7 above)

# line 8 - "cycle," "peck1," "peck2," "peck_clr," "chip_brk," "dwell," "shldr_angle," root_dia "(tap)," bore_shift

# line 8 - Milling attributes (see tool_type in line 7 above)

# line 8 - "cut_able," "rgh_x," "rgh_z," "fin_x," "fin_z," "tip_dia," root_dia (thd "mill)," thd_angle

# line 9 - "pilot_dia," "flute_len," "oa_len," "shldr_len," "arbor_dia," "hldr_dia," "hldr_len," "spindle_ccw," fm,"

# line 10 - Holder "type," Work "offset," Initial dir "vector[3]," Head "offset[3]," Tool offset[3]

#

# (tool types) (tool capabilities) (canned cycles)

# CENTER DRILL 1 ROUGH & FINISH 0 SIMPLE DRILL 0

# SPOT DRILL 2 ROUGH 1 PECK DRILL 1

# DRILL 3 FINISH 2 CHIP DRILL 2

# TAP-RH 4 TAP 3

# TAP-LH 5 (tool corner radius) BORE1 4

# REAMER 6 NONE 0 BORE2 5

# BORING BAR 7 CORNER 1 MISC1 6

# COUNTER BORE 8 FULL 2 MISC2 7

# COUNTER SINK 9

# END MILL FLAT 10 (coolant types)

# END MILL SPHER 11 OFF 0

# CHAMFER MILL 12 FLOOD 1

# FACE MILL 13 MIST 2

# SLOT MILL 14 TOOL 3

# CORNER RAD MILL 15

# DOVETAIL MILL 16 (spindle direction)

# TAPER MILL 17 CW 0

# LOLLIPOP MILL 18 CCW 1

# END MILL BULL 19

# BLOCK DRILL 20

# *** DO NOT REMOVE LINE NUMBERS OR DELETE ENTIRE LINES! ***

# *** ALL TOOL DEFINITIONS MUST CONTAIN 10 LINES AND THE 'TOOL' LABEL! ***

#

 

1 - TOOL

2 - 2

3 - 63mm face mill

4 - T:MASTERCAMTOOL-LIBRARYSFLATMILL.MC9

5 - A-6302-A

6 -

7 - 1 13 0 63 0 0 45 1 1 4000 3000 50000 12000 1 6 1 1

8 - 0 75 3.703704 138.888889 0.37037 63 0 0

9 - 0 6.25 50 18.75 55 50 25 0 0 0 1

 

1 - TOOL

2 - 2

3 - 16mm slot drill

4 - T:MASTERCAMTOOL-LIBRARYSFLATMILL.MC9

5 - B-1602-F

6 -

7 - 11 10 0 16 0 0 45 11 11 4000 2000 50000 15000 1 2 1 11

8 - 0 75 37.5 468.75 1.25 1 0 0

9 - 0 41 62 41 16 20 10 0 0 0 1

 

1 - TOOL

2 - 0

3 - 1MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K001

6 -

7 - 999 3 0 1 0 0 118 0 0 292 1000 5000 12160 1 2 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 12 16 12 1 50 25 0 0 0 1

 

1 - TOOL

2 - 0

3 - 1.5MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K006

6 -

7 - 999 3 0 1.5 0 0 118 0 0 195 1000 5000 8170 1 2 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 18 26 18 1.5 0 0 0 0 0 1

 

1 - TOOL

2 - 0

3 - 2MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K011

6 -

7 - 999 3 0 2 0 0 118 0 0 511 1000 5000 6080 1 2 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 24 35 24 2 0 0 0 0 0 1

 

1 - TOOL

2 - 0

3 - 2.5MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K016

6 -

7 - 999 3 0 2.5 0 0 118 0 0 409 1000 5000 4864 1 2 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 30 43 30 2.5 0 0 0 0 0 1

 

1 - TOOL

2 - 0

3 - 3MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K021

6 -

7 - 999 3 0 3 0 0 118 0 0 544.32 544.32 544.32 4032 1 1 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 33 41 33 3 0 0 0 38 0.135 1

 

1 - TOOL

2 - 0

3 - 3.5MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K026

6 -

7 - 999 3 0 3.5 0 0 118 0 0 466.56 466.56 466.56 3456 1 1 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 39 50 39 3.5 0 0 0 38 0.135 1

 

1 - TOOL

2 - 0

3 - 4MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K031

6 -

7 - 999 3 0 4 0 0 118 0 0 408.24 408.24 408.24 3024 1 1 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 43 55 43 4 0 0 0 38 0.135 1

 

1 - TOOL

2 - 0

3 - 4.5MM DRILL

4 - T:MASTERCAMTOOL-LIBRARYSDRILL.MC9

5 - K036

6 -

7 - 999 3 0 4.5 0 0 118 0 0 362.88 362.88 362.88 2688 1 1 0 999

8 - 1 200 200 50 100 0 0 0 0

9 - 0 47 60 47 4.5 0 0 0 38 0.135 1

---

Does anyone see anything wrong with this????????

 

 

Bruce

[Bruce Caulley]

There is a line space between lines 9 and 1 but it didn't show when I pasted it. Is this a clue?

[Bruce Caulley]

Still having no luck. I am sure something like this was discussed recently. Does anyone remember a similar topic in the not so distant past. I tried serching but came up with nothing.

 

Bruce

[Rekd™]

Dang, Bruce... You've almost carried on a complete conversation with yourself. Do you do this at home too?

 

All I can offer is a suggestion for a work around, using VBS to parse the file and convert it to tab delimited and re-save it.

 

Sorry, no time for code samples.

[Roger Martin from CNC Software]

Bruce,

 

If you wish to mail me a copy of the (TEXT format) Tool Library file you are tryng to import I'll take a look at it.

 

Roger

[Bruce Caulley]

Thanks Roger, I'll do that when I get back to work tommorow.

 

Rekd, depends on who you ask.

 

Bruce

[Bruce Caulley]

Roger,

File is on ftp. trial3.txt under tool and material libraries folder.

 

Bruce