Alexey Trebukhin Posted September 16, 2020 Share Posted September 16, 2020 Hey everyone! I started to use VWX Spotlight in 2019 and I always face with some-kind of unpredictable issues that I used to think would be a "one button solution" for such a software. Most annoying thing is that it's not possible to make a report with counts of weight and wattage for the hanging position because weight and wattage are the text fields. But! My friend spend about 1,5 hrs in pyth and wrote script that converts those fields in numbers in one column and text in another(kg/w/etc.*) please find pics below. This script even adds those parameters in Basic reports as an option to choose. Well, my main question is: Why WVX inc. cannot do the same function as a stock in the spotlight(I've seen some topics about that issue before in this forum)? I don't know python lang(hope someday I will learn it) but I do really want and need some kind of this option to be in the Spotlight. It would be perfect if would be automated report as "Position summary". Am I missing something? Any thoughts? PS: yes I know that this report doesn't include truss weight but I hope WVX inc. will make this "one button solution" one day with calculation of weights not only for the lighting units but for speaker arrays and projectors as well. Quote Link to comment
Vectorworks, Inc Employee jcogdell Posted September 21, 2020 Vectorworks, Inc Employee Share Posted September 21, 2020 There is a worksheet function that can convert text to numbers The thread linked below provides some good info about how to use the '=Value()' function Quote Link to comment
Alexey Trebukhin Posted October 14, 2020 Author Share Posted October 14, 2020 @jcogdell thank you! I tried before this function and it works if you have only numbers in the field, but if you have units like "kg" or "W" in the same field, this function doesn't work! 😞 I couldn't find formula or function that could split units and numbers and put it in 2 different fields. Is there something similar to Excel function "Text to columns" in VWX? Quote Link to comment
Pat Stanford Posted October 14, 2020 Share Posted October 14, 2020 Substring is the Worksheet function you are looking for. More details on its use in these threads. 1 Quote Link to comment
Recommended Posts
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.