I would like to know if it's possible to add a line return to a concatenate string.
I have this in the Text property of a label:
It returns this:
I would like it to return like this, but only if it will keep that formatting when patched to a SharePoint multi-line (Rich Text) field:
European Union, Austria, AT
European Union, Belgium, BE
European Union, Bulgaria, BG
Hi,
Add a "& Char(13)" at the end of the line. It adds a new line character to your string.
Good luck!
To add a line return you can use either of these:
Char(10)
Char(13)
The HTML version of this for Rich Text would be
<br>
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Sorry for the 'Noob' question, can you show me where in that line I would add it?
I am sure I will mess it up about a dozen times if I try myself.
Thanks
@JR-BejeweledOne
Yes, but can you supply the current code in Text format please? I don't want to retype it from your image. I'm too lazy for that lol.
I had to laugh because that's the exact reason I did a screen shot, although I suppose I 'could have' copied and pasted. I think it's a little easier to read when it's got the colors, and I am FAR to lazy for that.
Left( Concat( Filter(Markets, !IsBlank(Region) && !IsBlank(Country) && !IsBlank(CountryCode)), Region & ", " & Country & ", " & CountryCode & "; " ), Len(Concat(Markets, Region & ", " & Country & ", " & CountryCode & "; ")) - 2 )
Here's where the code should be placed:
Left( Concat( Filter(Markets, !IsBlank(Region) && !IsBlank(Country) && !IsBlank(CountryCode)), Region & ", " & Country & ", " & CountryCode & "; " ), Len(Concat(Markets, Region & ", " & Country & ", " & CountryCode & ";"&Char(13))) - 2 )
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Unfortunately that did not work.
User | Count |
---|---|
252 | |
106 | |
96 | |
50 | |
39 |