Text editing

I would like to use the email string and cut of the domain portion - convert jelena.dolic@xxxxx.com into
jelena.dolic

Please help

Unfortunately Glide computed columns do not support sting manipulation functions, so there is no easy way to do that within Glide. The simplest way to achieve that at the moment would be with a GSheet function.

1 Like

Thanks, sound great, but there I would have to figure out how to force a calculation on a newly created line. Would you be able to suggest?
Thanks

yes, you can use an ARRAYFORMULA

1 Like

=arrayformula(if(A2:A="",,left(A2:A,find("@",A2:A)-1)))

change A2:A if email is not in first column

Thanks :grinning: