How to extract part of a [:CommandValue]

I have this Taxa de Entrega Automation command

I know that I can get from Boa Esperança (R$3) the 3 part?

I used to remember that we could get right or left or middle chars, searched, but could not find it…

sorry if its silly…

Thanks!!!

use substr(start,length). I don’t know you have () or not but example base on no ()
[:CommandValue]'.substr(2,1) or
[:CommandValue]'.substr('[:CommandValue]'.length,-1)

3 Likes

Thanks, tonight will give it a try!!

Thank you very much!!!

G.

1 Like