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!
Advertisement