Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Bug in [tableindex] value in visio if Pipe “|” character exist in the index of that table

Solved1.56K views9th June 2021bug pipe tableindex Visio
2
Ladan Razeghi [DevOps Enabler]1.08K 9th June 2021 0 Comments

If index of table contains pipe "|" character, when using [tableindex] placeholder in visio, visio consider pipe as part of code and won't add any character after the pipe to the index value. I have tested that using session variable and had to replace "|" with "/" in order to use [tableindex] placeholder

Ladan Razeghi [DevOps Enabler] Selected answer as best 9th June 2021

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Toon Casteele [SLC] [DevOps Enabler]6.97K Posted 9th June 2021 2 Comments

Hi Ladan

In most cases where your content has a character that is used as a separator in the same shape data, you can use the "[sep:<defaultSeparator><newSeparator>]" to work around this. In your case the defaultSeparator will be '|' and your newSeparator can be any character you're not using in your actual content (such as '~'). Then your "[sep:|~]" can be placed at the start of the part that gets split on this character and everything should work fine.

For instance, when you have a condition that is formed as follows:

<A>and<B>-A|Value|randomValue|=true-B|Value|[tableIndex]|=false

Your sep placeholder can be added where you define that condition as follows:

<A>and<B>-A|Value|randomValue|=true-[sep:|~]B~Value~[tableIndex]~=false

Now, let's say instead of a '|' your content contains a '-'. In that case you have to place the sep placeholder at the very start of your shape data since the '-' is the split character for the larger parts of your condition and not just the definition of one of them. In that case, you can do this:

[sep:-#]<A>and<B>#A|Value|valueWith-|=true#[sep:|~]B~Value~[tableIndex]~=false

I realize it's a bit abstract to explain in text, but try to split the parts up into their smaller and bigger components and it should be clear:

  • [sep:-#]
    • <A>and<B>
    • A|Value|valueWith-|=true
    • [sep:|~]
      • B
      • Value
      • [tableIndex]
      • =false

I took extended conditions as an example because they contain a lot of split characters but this should go for most if not all shape data where it can be necessary (it won't work for options that have predetermined values such as AllowInheritance=True/False, but it's not needed there anyway).

The extended conditions dataminer help page also has this info if you want to see it from a different writing standpoint.

Ladan Razeghi [DevOps Enabler] Selected answer as best 9th June 2021
Ladan Razeghi [DevOps Enabler] commented 9th June 2021

Hi Toon
I know about the separator but how do you use it in Setvar and Variable data. My visio is actually very simple. In SetVar I set “Test:[tableindex]” and in Variable shapedata I just put “Test”.
In this case if [tableindex] is “PICK|PIK|1832” then in variable shape it’ll only display “PICK”.
I didn’t try “Test:[Sep:|^][tableindex]”. so I’m not sure if that works or not

Toon Casteele [SLC] [DevOps Enabler] commented 9th June 2021

Yes, you are completely correct with your last example! As I explained in my answer, the sep placeholder should always be placed at the start of the parts where the split happens. In this case the format is : where possibleValues is split with a ‘|’ by default. That means your sep placeholder should go in front of the possibleValues part if your value contains a ‘|’.

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin