Hello, I'm trying to do this:
ifelse(locate({Billing Value},"token") DIFFERENT(i cannot put it on the post I dont know why) 0,
locate({Billing Value},"token"),
"blop"
)
but I get an error, which seems to be related to the fact of using locate as a field, but I don't understand what is going wrong.
Basically what I try to do is locate the word "token" in a field, and if it is found, I want to return its position in the string
Thanks a lot,
Tomy
Edited by: tblondeau on Oct 12, 2021 3:59 AM
Edited by: tblondeau on Oct 12, 2021 3:59 AM