in a field called p1::tn1 i want first letter of the word with font1 and characters after 1st should be font2 i wrote script but no success where am i wrong kindly someone help me plz

 Upper(TextSize(TextFont(TextColor(Left ( P1::TN1 ; 1 ); RGB( 0 ; 0 ;0  )); "font1" ) ; 12))  &  Upper(TextSize(TextFont(TextColor(Middle ( P1::TN1 ; 2 ; P1::TN1 ); RGB( 0 ; 0 ;0  )); "font2" ) ; 12))

Try

 Upper(TextSize(TextFont(TextColor(Left ( P1::TN1 ; 1 ); RGB( 0 ; 0 ;0  )); "font1" ) ; 12))  &  Upper(TextSize(TextFont(TextColor(Middle ( P1::TN1 ; 2 ; Length(P1::TN1 )-1); RGB( 0 ; 0 ;0  )); "font2" ) ; 12))

success edited few things got what i want thanks a lot doughemi

Wouldn't it be sufficient to do =

Upper (
TextFont ( Left ( TN1 ; 1 ) ; "Font1" )
&
TextFont ( Right ( TN1 ; Length ( TN1 ) - 1 )  ; "Font2" )
)

and apply the rest of the formatting (size and color) at layout level?

 

In any case, there's no point in writing the same thing twice - so if you really need it, do: =

TextSize ( TextColor ( Upper (
TextFont ( Left ( TN1 ; 1 ) ; "Font1" )
&
TextFont ( Right ( TN1 ; Length ( TN1 ) - 1 )  ; "Font2" )
) ; 0 ) ; 12 )

Note that RGB ( 0 ; 0 ; 0 ) is 0.

---
P.S. This is a calculation, not a script.