Topic: Schedules - Forulas - VB if then statement to check object is pipe HELP

[Jeff H]

Just figured out how to do public links with dropbox
 and when you get it and it works let me know and I will remove it from mine since it is almost full

*******************************Edit**********************
Removed old file link

[DIW_CADtech]

This is soo CLOSE...

I need to work out the lengths... they need to post in feet and inches

i.e.  120 = 10'-0"

Link to the current file is.....
http://dl.dropbox.com/u/20790817/testing04.dwg


thanks again Jeff

[Jeff H]

Quickest way and if just wanting to show in schedule.

---Select schedule
---Edit Style
---Select Length Column
---Modify
---Change Data Format

[Jeff H]

Next step is to get Jeff_M away from Civil and into MEP so we would have someone to teach us VB and how to use MEP .NET API

[Jeff_M]

Now that is humorous and flattering Although in my brief perusal of MEP (20 minutes or so) I'm seeing things I wish we had IN C3D. I'm leaving on a 2+ week vacation Sunday, perhaps I'll find some time to play around in the MEP world.

[DIW_CADtech]

http://dl.dropbox.com/u/20790817/testing05.dwg

The point is to only have 3 columns
and the proper format for the length in the Description is feet and inches

i.e. 120 = 10'-0"

I have the extra columns because i'm trying to understand how it works, but I don't want those.

Need to get it into the description correctly.  I hope this is still possible.

[DIW_CADtech]

Seriously.. the more people in the MEP forum  the better...  feel like I'm swimming with weights...

[DIW_CADtech]

Unit Feet and inches does NOT seem to work either.. it seems to round to the nearest foot and does not include the marks ( ' ) or ( " )

[DIW_CADtech]

I even tried to break out the feet inches and 1/16ths to seperate DataSetDefinitions from the [length] and then concatenate them in a DataSetDefinition [PIPELEN] 

I did have to use Chr(34) Chr(39) and Chr(47)  and it worked as a stand alone.. but once I introduced [PIPELEN] as a separate column... pthh... it went bust

So never got it to concatinate in the first place...

I'm bushed... calling it a night...
http://dl.dropbox.com/u/20790817/testing06.dwg    is the polished ver of 5

http://dl.dropbox.com/u/20790817/testing07.dwg    is my foolish attempt at using Chr()

take a look... or skip if you have a better idea and post that....