Concatenating text elements
-
SketchUp Version: 8
I am trying to create an Item Code thusly:
="6072"&if(PatioCover!BeamHt<=96,"08",if(PatioCover!BeamHt<=120,"10",if(PatioCover!BeamHt<=144,"12","14")))&PatioCover!PostCol
should result in 607208WH
but what I get is 60728WH
Completely illogical esp. since I have everything in quotes and esp. since the last item in the formula resolves to "WH" which would force any spreadsheet (for example) to identify the result as text. -
@buckyman said:
SketchUp Version: 8
I am trying to create an Item Code thusly:
="6072"&if(PatioCover!BeamHt<=96,"08",if(PatioCover!BeamHt<=120,"10",if(PatioCover!BeamHt<=144,"12","14")))&PatioCover!PostCol
should result in 607208WH
but what I get is 60728WH
Completely illogical esp. since I have everything in quotes and esp. since the last item in the formula resolves to "WH" which would force any spreadsheet (for example) to identify the result as text.I never experienced this problem !... but I never use &
I prefer use CONCATENATE function, and your problem is solved, a "0001" is really "0001" not "1"
So your function will be something like
= CONCATENATE ("6072", if(PatioCover!BeamHt<=96,"08", if(PatioCover!BeamHt<=120,"10", if(PatioCover!BeamHt<=144,"12","14"))), PatioCover!PostCol) -
Well that's a bit embarrassing, I guess I should have checked out the available functions.
Thanks for your help!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login
Advertisement