Question about Drawing Label

[alrale]

hi, everyone. I have a question about SP3D drawing label. Pls share me your mind, thanks.

For example, an equipment Named as "P101A" in model, but need label it as "P101" in SP3D drawing.

So I need make a label to clear the last letter "A". Who can tell me how to customize the label?

[tim]

Define new label as SQL type.
If equipment name has fixed length (in your example P101), substring function can be used to extract fixed length data.



select substring(ItemName,1,XX) from JNamedItem where oid=?

[alrale]

Thanks for Tim's reply.B)

I'll try it.


Define new label as SQL type.
If equipment name has fixed length (in your example P101), substring function can be used to extract fixed length data.



select substring(ItemName,1,XX) from JNamedItem where oid=?