i have feild that containing kod , for exm. 12f , 13i, 14s, 12i , 12s...
the sign is color and the number is Texture.
i want to make new feild that containing the all kod with "s" how can i do it ?
thank's for your help.
Load if((Right(KOD,1)='s'),KOD)as Kod1;
LOAD * INLINE [
Try this script
Load If(Index(KOD, 's'), KOD) AD TempKod;
Hope this helps you.
Retrieving data ...