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
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.
Excelent! Thanks Translate
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
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |