Jump to content

Graphic Legends - Removing Overarching Class Heirarchy Heading


Recommended Posts

Use the Worksheet functions will get you what you want.  They are not all available from the pulldown, so you will probably have to type it in.  Check the third line for what you want.  #C# and #WS_Class# return the same value.  

 

Substring returns a part of a string that is separated by a delimiter character.  I am passing the worksheet version of the Class name to the Substring with a delimiter character of dash ('-').  The delimiter has to be separated by single quotes.  Since I want the part that comes after the dash I tell it 2 for the section I am getting.

 

If you use multiple levels of nested classes I don't know if this will get you everything except the first level or only the second level. I think it will only get you the second level between the multiple dashes.

 

HTH.

 

(My test file had two classes Element-Hello and Element-Goodbye).

 

image.png.eac428787801ac01db96584402da96ab.pngimage.png.018dfa02d019c851c920c05f490ab4d0.png

  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...