Separate feild to 3 feilds

[Anonymous]

hay

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.

yarin.

[sreenivas]

Table:

Load if((Right(KOD,1)='s'),KOD)as Kod1;

LOAD * INLINE [

   KOD

   12f

   13i

   14s

   12i

   12s

];

[jagan]

Hi,

Try this script

Test:

Load If(Index(KOD, 's'), KOD) AD TempKod;

LOAD * INLINE [

   KOD

   12f

   13i

   14s

   12i

   12s

];

Hope this helps you.

Regards,

Jagan.