Modifying code

[ptrifile]

I am using the following code to take and combine values from:

BBuy HT T1
BBuy PC T1
BBuy HT T2
BBuy PC T2


to

T1
T2

stringvar array x := split({splitTable1.Split_Name}," ");
x[ubound(x)]

how would i change that code to change the following from:

BBuy T1A Tfr
BBuy T1A Field
BBuy T2A Tfr
BBuy T2A Field

to

T1
T2

Thanks for any help

Paul

 

[lbass]

If you literally only want to check those two codes, you can use:

if "T1" in {table.field} then "T1" else
if "T2" in {table.field} then "T2" else
{table.field}

-LB

 

[IanWaterman]

If the text you want is always the second block after a space and comprises two characters.


left(split({YourString}, " ")[2],2)

Ian