Hello,
Is it possible to trim the text in 3 parts?
Demo: John Doe First
Even if some customer has a name Mary Jane
Subtitle_Cust => a label
For example, i use in HtmlText Label
"<b>" &
Left(Subtitle_Cust,
Find(Last(FirstN(Split(Subtitle_Cust, " "),2)).Result
,Subtitle_Cust)-1)
&
"<font color=blue>" & Trim(Last(FirstN(Split(Subtitle_Cust, " "),2)).Result) & "</font>"
This gives me John
Then blue gives me Doe
Now i still needs to display First
So i get John Doe First
Or Mary Jane
Thanks
Solved! Go to Solution.
Hi @TimmyBoy ,
Please try:
"<b>" &
Last(FirstN(Split(Subtitle_Cust, " "),1)).Result
&" "&
"<font color=blue>" & Last(FirstN(Split(Subtitle_Cust, " "),2)).Result & "</font>"
&" "&
If(CountRows(Split(Subtitle_Cust, " "))>2,Last(FirstN(Split(Subtitle_Cust, " "),3)).Result,Blank())
& "</b>"
Best Regards,
Wearsky
Hi @TimmyBoy ,
Please try:
"<b>" &
Last(FirstN(Split(Subtitle_Cust, " "),1)).Result
&" "&
"<font color=blue>" & Last(FirstN(Split(Subtitle_Cust, " "),2)).Result & "</font>"
&" "&
If(CountRows(Split(Subtitle_Cust, " "))>2,Last(FirstN(Split(Subtitle_Cust, " "),3)).Result,Blank())
& "</b>"
Best Regards,
Wearsky
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |