say i have a field with a number such as this

[color:red]12748a030827

i already have this being figured out. as far as what it means.

like this:

[color:blue]Let([

Issue = Middle(MyText;4;2);

Alpha = Middle(MyText;6;1);

Category = Case(Alpha = "a"; "Automotive"; Alpha = "b"; "Boat"; Alpha = "h"; "Home"; Alpha = "q"; "Internet"; Alpha = "t"; "Truck"; Alpha = "r"; "Bargain"; "");

TextToDisplay = Category & " " & "Ad Issue" & " " & Issue

];

TextToDisplay

)

this is not my problem this is my problem every now and again the number will change to something like this [color:red]#240084

well as you can tell this will not work with the script above all i want is this if the number doesn't start with a [color:red]1 i want it to display with what ever is its default value. [color:red]#240084

Edited November 17, 200520 yr by Guest

Hi

if I understood you correctly, this is pretty simple:

[color:blue]Let([

[color:red]firstChar = Left(MyText;1);

[color:blue]Issue = Middle(MyText;4;2);

Alpha = Middle(MyText;6;1);

Category = Case(Alpha = "a"; "Automotive"; Alpha = "b"; "Boat"; Alpha = "h"; "Home"; Alpha = "q"; "Internet"; Alpha = "t"; "Truck"; Alpha = "r"; "Bargain"; "");

TextToDisplay = Category & " " & "Ad Issue" & " " & Issue

];

[color:red]Case(

firstChar = 1;TextToDisplay;MyText

)

[color:blue])

perfect god i really need to learn this more that was a simple answer

what about this is the first char has a # how would i change it to say something like ;MyText & " Paid Thank You" &

Let([

firstChar = Left(MyText;1);

Issue = Middle(MyText;4;2);

Alpha = Middle(MyText;6;1);

Category = Case(Alpha = "a"; "Automotive"; Alpha = "b"; "Boat"; Alpha = "h"; "Home"; Alpha = "q"; "Internet"; Alpha = "t"; "Truck"; Alpha = "r"; "Bargain"; "");

TextToDisplay = Category & " " & "Ad Issue" & " " & Issue

];

Case(

firstChar = 1;TextToDisplay;

[color:red]firstChar = "#";MyText & " Paid Thank You";

MyText

)

)

awsome