htmltext trim

[TimmyBoy]

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

[v-xiaochen-msft · Accepted 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

---

[TimmyBoy]

@v-xiaochen-msft 

Just awesome, yes this is what i was looking for 😄

Thank you so much.