Take only part of the text

I need to get only part of luizsalgadinho @ hotmail.com, it would not always be that email, but I know I would have to pick up after the word ENVIO:
I’m very lazy on the subject.
can anybody help me?
Thank you

[BKO TOP| PF| AIR TIME_EXCEDENTE | LOJA DE SERVIÇO| PROCEDENTE | NC|E-MAIL PARA ENVIO: luizsalgadinho@hotmail.com|título e o valor a ser ajustado:120131BEAA 20180917173571/89,82| VALOR PRO-RATA:0,00|VALOR:89,82|NÚMERO DO CONTRATO:21001463| RESOLVIDO|RESUMO DA ANALISE:CLIENTE COBRADO POR VALORES REFERENTES A LOJA DE SERVIÇOS NÃO SOLICITADOS POR ELE DE 08 A 10/18. R$ 89,82. SERVIÇOS CANCELADOS.| CONTATO COM O CLIENTE VIA SMS | TELEFONE: 5521964116026|]

1 Like

Hey,
I hope this helps, it might not be perfect but it should get the job done, unless someone has a better idea?
If you’ve got any questions let me know!
Thanks

_Sandbox.xaml (8.2 KB)

3 Likes

Kinda lengthy but works :grin:
Say your string is stored in a variable var
var.Substring((var.IndexOf("ENVIO: ")+7),var.IndexOf("|", var.IndexOf("ENVIO: "))-(var.IndexOf("ENVIO: ")+7))

3 Likes

worked thank you :slight_smile:

2 Likes

worked thank you

1 Like

I knew there’d be a quicker way but I’m still learning string manipulation myself too :slight_smile:

1 Like

yup! just some trial and errors before I get this :stuck_out_tongue:
there would surely be better ways that mine here :wink:

1 Like