Piotr Karczewski Posted October 28, 2022 Share Posted October 28, 2022 (edited) Hi, I'm trying to figure it out formulas combination in reports especially combining =SYMBOLNAME & TrimLeft I want to trim first 8 digits from the result of =SYMBOLNAME formula, which bigins with 7 numbers and SPACE after it. Please provide me a construction how to combine different formulas for the future... I haven't found it in neither in help file and "https://developer.vectorworks.net/index.php?title=Worksheet_Functions" Any suggestions? Thx for Your help in advance. PS =TRIMLEFT(SYMBOLNAME; 8) (returns =SYMBOLNAME) & =DELETE(SYMBOLNAME,8, 1) 😎 does not work Edited October 28, 2022 by Piotr Karczewski adding details Quote Link to comment
Pat Stanford Posted October 31, 2022 Share Posted October 31, 2022 This first one using Right seems closest to what you are trying to do. =Right(C3, Len(C3)-8) If you know that the space between the number and the name is the only space in the string, then you could use =Substring(C3, ' ', 2). Where there is one space between the two single quotes If you really want to use TrimLeft you can, but you have to use it properly =TrimLeft(C3, '1234567890 ') The second parameter is a single string that contains each of the digits and a single space. The order does not matter. Any character matching and character in the Chars string will be removed from the left end of the passed string. If you have a symbol name that contains a number as the first character after the space, that number will be removed also. HTH. 1 Quote Link to comment
Piotr Karczewski Posted November 10, 2022 Author Share Posted November 10, 2022 Thx @Pat StanfordI do really apreciate Your help! I have to rethink what You wrote and check what will be the best solution. 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.