Concatenate Recommended Field Voucher मुफ़्त में

if you've created some calculations in the past you know that concatenation use the ampersand it's like the plus sign for text gluing two or more pieces of text together into a single string it's pretty easy to do so I want to show you how you can conditionally concatenate without case choose or if so here's a pretty common scenario you have three fields first name middle name and last name and you want to put them together into one string you can see both of these formulas here put them together perfectly and if we remove the middle name you'll see there's not an extra space in there so let's see how that works we'll go up to our first choice which is this one and this is pretty common we take the first name which we're assuming is always filled and the last name which we're assuming is always filled but in the middle putting a case statement saying if there's something inside the middle name in other words not is empty the opposite of is empty which would be is full but there's no is full function so we just put the not function in front of it if there's something in it then take the middle name and add a space otherwise the default is empty or nothing for the case statement so that works great it's a you know a little bit of work here to type the case statement let's say how you do it with the substitute function what you do is you take the list function now the list function is pretty cool what it does is allows you to put together values and returns library lists so since we're working from the inside out we'll go put some returns here this gets done first so the result of this will be John then a return mark then a return as what the substitute function does say take these returns which are right there and there and replace them with spaces so in this case it puts a space there if I could type a space there we go and does that but if there's no middle name what ends up happening is we don't get a blank return in there we get no return in there we get just John Osborne it's just the way that the list function works because this is empty it doesn't put a value separator so the substitute function then works on it this way inputs just a single space between it so that's pretty cool because it's a lot easier to write this in my opinion than the case statement it's less verbose and it really comes in handy and shines when you look at another example so let's go and take a look at it here's an example of a mailing label you can see that both are able to distinguish between having the address to filled or not filled or if we take the company out it'll pop back up both work fine one uses case or if if you like and one use substitute so we'll come in here look at the case one first you can see we have quite a few cases we have a case up here to check if the companies filled case right here to see if the middle without it's the same as what we did before the middle name check you to see if the address two is filled and again with the company and the...