Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
MicroStation
  • Product Communities
MicroStation
MicroStation Wiki How to change all numeric Text elements from 4 to 2 decimal places
    • Sign In

    • -MicroStation Wiki
      • +Learning Tips
      • -MicroStation
        • +3D Printing - MicroStation
        • +Animation - MicroStation
        • +Archive / Backup - MicroStation
        • +Base Geometry - MicroStation
        • +Batch Processing - MicroStation
        • +CONNECT Advisor - MicroStation
        • CONNECT Integration - MicroStation
        • +CONNECTION Client
        • +Cells - MicroStation
        • +Change Tracking - MicroStation
        • +Configuration - MicroStation
        • +Coordinate Systems - MicroStation
        • +Curves - MicroStation
        • +Custom Linestyles - MicroStation
        • +DGN - MicroStation
        • +DWG - MicroStation
        • +Database - MicroStation
        • +Detailing Symbols - MicroStation
        • +Dimensions - MicroStation
        • +Documentation & Help - MicroStation
        • +Drawing Aids - MicroStation
        • +Exception - MicroStation
        • +FAQ - MicroStation
        • +Feature Based Solids Modeling - MicroStation
        • +File Access - MicroStation
        • +GUI - MicroStation
        • +General - MicroStation
        • +Graphics Display - MicroStation
        • +Groups - MicroStation
        • +Hardware / Input Devices - MicroStation
        • +Import/Export - MicroStation
        • +Installation - MicroStation
        • +Interchange - MicroStation
        • +Interference - MicroStation
        • +Internationalization - MicroStation
        • +Levels - MicroStation
        • +Licensing - MicroStation
        • +Manipulation - MicroStation
        • +Markup / Redline - MicroStation
        • +Measure - MicroStation
        • +Mesh - MicroStation
        • +Models - MicroStation
        • +Multi-Lines - MicroStation
        • +OLE - MicroStation
        • +Other - MicroStation
        • +Parametrics - MicroStation
        • +Patterning - MicroStation
        • +Point Cloud - MicroStation
        • +Printing - MicroStation
        • +Programming - MicroStation
        • +Project Navigation - MicroStation
        • +Properties - MicroStation
        • +RSS Feeds - MicroStation
        • +Reference - MicroStation
        • +Security - MicroStation
        • +Selection - MicroStation
        • +Settings - MicroStation
        • +Sheet Composition - MicroStation
        • +Solids - MicroStation
        • +Standards - MicroStation
        • +Surfaces - MicroStation
        • +Tables - MicroStation
        • -Text - MicroStation
          • +Favorites - Text - MicroStation
          • +Fields - Text - MicroStation
          • +Find / Replace Text - Text - MicroStation
          • +Font Installer - Text - MicroStation
          • +Fonts - Text - MicroStation
          • -General - Text - MicroStation
            • Add or Fill in text in empty text node(s)
            • All decimal separators ignored
            • Are there keyin's for changing the text and text node justification
            • Cannot delete Text nodes from file
            • Change Text Case
            • Change text case using a key-in
            • Configuration Variable for Chinese Language
            • Converting Text to Text Nodes
            • Copy and paste foreign characters
            • Edit text results fraction
            • Exception when exporting visible edges for a large model
            • Filled data fields shift slightly to right
            • Hebrew text is not displayed correctly
            • How do you change the line length setting for a placed text node in MicroStation V8i?
            • How MicroStation handles the spacing of characters
            • How to Associate Text to an element in CONNECT Edition
            • How to change all numeric Text elements from 4 to 2 decimal places
            • How to change existing text nodes from "View Dependent" to "View Independent"
            • How to copy \ increment text at a desired location
            • How to Copy/paste multiple lines of text, and paste them in a different order to how they are viewed.
            • How to create Text Nodes from text strings.
            • How to Display Formatting Symbols (i.e. Carriage Returns, Space Symbols, etc.) in MicroStation Text Editor
            • How to edit a piece of text through the key-in window without using the mouse to select a piece of text in MicroStation v8.
            • How to edit stack fraction text without losing the fraction
            • How to remove unused fonts from a design file
            • How to resize or scale text in one direction
            • How to turn off the display of text nodes
            • Invalid Font Config, MstnFontConfig.xml
            • Keyin Place Text Q/ quits program
            • Make Annotations Appear in all Views
            • Microstation Abort when editing text.
            • Multiline Text Spacing For Stacked Fractions
            • Place Text Key-in Method Origin
            • Placing a symbol on a property line
            • Quickly change all of the text and dimensions to current Annotation scale
            • Rotate text placed at arbitrary angle back to 0 or 90 degree
            • Set Text to Italic mode with a Key-in
            • Text Editor style is set to Dialog Box
            • Text node Justification in MicroStation J
            • Text on top of Other Elements
            • Text size limit in Microstation?
            • Text still seen on cursor when text node lock is on
            • Text using True Type Font (TTF) not visible front view
            • Text with Slash is displayed reverse
            • TrueType font Texts are displayed outlined when referenced
            • Unable to extrude text with Feature Modeling
            • Upside-down text placement
            • What are the limitations of text characters?
            • What happens to text when upgrading V7 files?
            • When editing text Microstation inputs edited string as new Text in MicroStation J
          • +Match / Change Attributes - Text - MicroStation
          • +Spell Checker - Text - MicroStation
          • Text Audit - Text - MicroStation
          • +Text Styles - Text - MicroStation
          • +Word Processor - Text - MicroStation
        • +UI Customization - MicroStation
        • +Units - MicroStation
        • +View - MicroStation
        • +Visualization - MicroStation
        • Welcome Page - MicroStation
        • +Accreditation - MicroStation
        • +i.Models - MicroStation
        • +ProjectWise Integration
        • +Raster - MicroStation
    • +Administration Wiki
    • +Annotations Wiki
    • +Bentley View Wiki
    • +MicroStation PowerDraft
    • +Programming Wiki
    • +Visualization Wiki

     
     Questions about this article, topic, or product? Click here. 

    How to change all numeric Text elements from 4 to 2 decimal places

      Product(s): MicroStation
      Version(s): 10.11.00.36
      Environment: N\A
      Area: Text
      Subarea: General

    Problem

    How to change all numeric Text elements within a file from 4 to 2 decimal places.

    Solution

    The following workflow demonstrates one method, which involves a combination of techniques to identify the Text elements and their coordinate position, before exporting them to a third party application for reformat (Change the # of decimal places) followed by reimporting.

    STEP 1 - Identifying and selecting the element to be modified.

    There are various methods that could be used here such as using tools like Element Selection, Select By Attributes, Reports .. In this instance the Explorer's Advanced Search will be used.

    Open the Explorer (Drawing > Home > Primary > Explorer)

    Under the ‘File‘ Section, select the ‘ Advanced Search' tool.

    In the Advanced Search dialog search for 'Text' by defining the parameters required to select the Text to be changed. (See the Help for further detail) and ‘Add to Search’ and click OK.

    The search results will appear in the Explorer dialog and the elements in the View will be selected.

    STEP 2 - Exporting the Text and their corresponding coordinates

    Right Click on the Search Results and select ‘Save As Report Definition'

     

    In the Reports dialog that opens with the Text Search Results add columns for the Text String and the x,y (Optionally Z) coordinates of their origin.



    For the Text String, expand Text > Contents and toggle on ‘Text String’

    Expand Text > Geometry and toggle on ‘Origin’ and select ‘OK‘

     

     

    To specify the Test Origins X coordiante right click on the Origin column and select 'Add Formatting'and in the Properties select the X coordinate.

     

      

     

    Right Click on the Column ‘Origin’ and select ‘Rename’ and give it an appropriate name ‘X’

    Copy and paste the Column 'X' and rename the copy to 'Y' and change its Format properties to pick up the 'Y' coordinate. (Repeat this step for 'Z'  if required)

     

     

    Verify the results using the Reports Preview tool before Exporting them to Excel or other format.

     

     

    STEP 3 - Reformat the Text to 2 Decimal places in the exported file

     

    Open the exported file in Excel or other application, and reformat the cells in the column 'Text String' to show 2 decimal places and remove Row 1 (Rremember the column order) before saving the file to csv format.

     

     

    STEP 4 - Importing the modified Text from the CSV file

     

    RECOMMENDATION : Before importing the Text take a backup of the Design file.

     

    Start by removing the Text element from the Design file, to do this in Explorer select the search created earlier, all the elements should now be selected and can be deleted using the Delete tool.

     

    Select the Import Coordinates Tool ( Drawing > Annotate > Terrain Modelling > Import Coordinates )

    In the Tool Settings browse/select the CSV file created earlier.

    Change the Import Type to ‘Text’

    Change the Order to match the CSV columns order (T stands for Text to be imported)

    Select Process.

     

     

    The Text elements should now appear in the Design reformated showing 2 decimal places.

     

    +++++

     

    Note: For Dimension elements containing 4 decimal places, these can be changed by modifying the Dimension Style used to place the dimension, or alternatively by defining a new Dimension Style with the Unit formatting required. This in turn can be applied to the dimensions using the Change Dimension tool.

     

    See Also

    Apply Dimension Style To Existing Dimensions-which-have-no-dimension-style

    How To Import Coordinates X Y Z And Their Respective Labels Or Text



      Original Author: Carl Myhill
    • text
    • xyz tool
    • GENERAL
    • reports
    • MicroStation
    • 10.11.00.36
    • en
    • Share
    • History
    • More
    • Cancel
    • Carl Myhill Created by Bentley Colleague Carl Myhill
    • When: Fri, Dec 7 2018 11:08 AM
    • Andrew Bell Last revision by Bentley Colleague Andrew Bell
    • When: Sun, Dec 9 2018 9:15 PM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies