HI, I want to extract the first element from ...

[Fer_Calvano]

HI, I want to extract the first element from the “Key” and paste it in the column “producto.empresa”. For example: in the first row, the table should contain the word “Lapiz”.

How should I do it?

Thanks Fernando

[Suvrutt_Gurjar]

Hi , Request you to try the expression =LEFT([Key],(FIND(":",[Key])-1)) in the column “producto.empresa”.

This expression is based on the assumption that the Key column values will always have a “:” character immediately after the first element. For example Lapiz: , Hora:

etc, as you have given in sample.

Hope this helps and works.

[Fer_Calvano]

Excelent! Thanks Translate

[Obed_Vazquez_Lo]

una mejor solución sería tenerlos separados desde la fuente. Probablemente te cause problemas en un futuro tener el color y el elemento juntos (o agarrarte de la llave para este caso) Translate