Text editing

Ask for Help
1

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

Please help

2

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
3

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

4

yes, you can use an ARRAYFORMULA

1 Like
5

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

change A2:A if email is not in first column

1 Like
6

Thanks :grinning: