using locate as a value inside if else

0

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

질문됨 3년 전322회 조회
1개 답변
0

ifelse(locate({Billing Value},"token") <> 0,
toString(locate({Billing Value},"token")),
"blop"
)
this fixes it, int needs to be parsed as string for this to work

답변함 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠