Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
MechMachineMan
in reply to: bespel

Mhm.

 

If you look at the material names, you will see that comma exists there already. The only comma that is added in MY CODE is the one right after the 'kg'.

 

You have 3 options forward:

 

1. Change the comma that is in the code, added before 'kg' to a different symbol to make it readable (ie; a ';', or a '-' would probably work.

 

2. MODIFY the material name when you accessing it with the code.

    - Depending on HOW you want to modify it you have various options.

 

    Option a: Reorder the name by moving everything behind the comma to the start of the string (ie; 'Steel, Mild' becomes 'Mild Steel')

    Option b: Replace the comma in the material name to another character (ie; 'Steel, Mild' to 'Steel [Mild]')

    Option c: WRITE the code to do a wholesale swap using a Select Case (ie; 'Steel, Mild' to '44W')

 

     If you go through option 2, you have 2 efficient options for where you want to access the MATERIAL NAME to change the commas: 

     Either BEFORE putting in in the dictionary, or WHEN you fetch it from the dictionary.

 

3. Modify material names in your library so that the material names appear how you want them to in the BOM / Output.

 


--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.

Justin K
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization


iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread

Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects

Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help

Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type