Custom Data Tag

[KAAC]

Hi All,

 

I am trying to parse some text that is showing on the ConnectCAD Drop Point annotation data tags. I want to split the cable type text via a Substring function and just use the latter part of the cable type text on the data tag.

I'm trying to do this in the Data Tag definition editor, using the underscores as delimiters, with the below syntax in the definition (see image), it's not working, anybody have any pointers of how to achieve this or what the required syntax is.

 

Thanks.

[Tom W.]

Try this:

 

=SUBSTRING('CC_Cabling'.'Cable Types', '_', 3)

[Tom W.]

Alternatively you can do it in the 'Advanced calculated field' pane using this:

 

#WS_SUBSTRING('CC_Cabling'.'Cable Types', '_', 3)#

[KAAC]

Thanks @Tom W. - I'll try both later today today and report back..

[KAAC]

Neither of the above worked unfortunately..

[Tom W.]

22 minutes ago, KAAC said:

Neither of the above worked unfortunately..

 

Post a small test file. When I tested it it worked but be better to see exactly what you're doing.

[Pat Stanford]

You probably need to use semicolons (;) instead of commas (,) as the separators in the formulas.  See my signature for more info.

[Tom W.]

2 minutes ago, Pat Stanford said:

You probably need to use semicolons (;) instead of commas (,) as the separators in the formulas.  See my signature for more info.

 

I thought of that but discounted it because they're in Ireland...?

[KAAC]

Thanks @Pat Stanford, @Tom W.

 

Attached is a testing file I have been messing with for this. Sht-1 has default data tags auto created by running the command Connectcad->Documentation->Create Cable Sheet.

Saved view Data Tags - Default will bring you to the default tags.

I have spent ages trying your suggested solutions and all variations of syntax with no luck.

Thanks.

 

Data Tags.vwx

[Pat Stanford]

Your CC_Cabling record is attached to the Data Tag and not to the Drop Point that it is associated with.

 

The Data Tag will only pull data from the object it is associated with, so you need to store the data with the Drop Point.

 

Or you can leave the Data Tags as is and just break the associations and then you will get what you want. But if you move the Drop Points, the Data Tag will not move with it.

 

Also, your Viewport on Sht1 is really weird. It is huge and the drop points are located at about 1.2Million meters from the origin. It appears that there are also other object located at about -1.2Million meters in the other direction, but I was not able to isolate them and zoom in on them to figure out what they are.  There are also about 5 stacked groups that run from the RK1 polygon at about 248,000 meters down to Zero in the Y direction.

 

Having these objects so far from the origin will also cause you problems in the future, but I don't think that is what is happening with the Data Tags.

[KAAC]

Thanks for that @Pat Stanford. I will get back in to it when I get a chance,

 

Yeh, that file is a file I use for testing only and there has been all sorts of crap in there over time so I am not surprised at your comments but I agree that is not the source of my data tag dilemma.

.

 

Thanks again...