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

(Fer Calvano) #1

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) #2

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) #3

Excelent! Thanks Translate

(Obed Vazquez Lopez) #4

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