Finding a string at the begining of another string in @Formula Language

HCL Domino Domino Forum
1

Hi

I am trying do to something so simple in @Formula that I cannot see how to do it :slight_smile:

I want to find out if a piece of text is in the beginning of another string.

For example I want to know if “dek” is in the string “dekhengst”.

I thought @IsMEmber would work but it gives me no result even if I know for sure that the text is in the beginning of the string.

Can someone help me out?

Regards

2

Subject: Finding a string at the begining of another string in @Formula Language

You can use @contains, but this will return true also if the string is “de dekhengst”.

If you really want to check if a string starts with “dek” you can use

@if(@left(“dekhengst”; 3) = “dek” …

Regards,

René

3

Subject: Finding a string at the begining of another string in @Formula Language

@Begins maybe?

4

Subject: RE: Finding a string at the begining of another string in @Formula Language

Now there’s another brilliant function of which I never knew it existed! Probably there since R3? :wink: