Access the n-th character of a string in a formula

Dear community,

It might be a nooby question but I couldn't find the answer on the forum.

I'm building a test module and I would like to check if the n-th character of a string is a " " (space). I couldn't find any easy way to extract this n-th character to check its value. Would you know a way ?

Thank you in advance !

Parse

Accepted answers

andyuttley

Hi @Titouan

You could use a formula to check this, such as:

"if Substring([YOURFIELD],3,1) = " " then 1 else 0 endif"

this would check the 4th character is " ", as an example

Andy

All comments

andyuttley

Hi @Titouan

You could use a formula to check this, such as:

"if Substring([YOURFIELD],3,1) = " " then 1 else 0 endif"

this would check the 4th character is " ", as an example

Andy

klyuka

iif (substring ([your_string], n-1, 1) = " "; 1; 0)

Titouan

Oh of course .. Thank you 🙂

LordNeilLord

Hey @Titouan

The easiest way is to split out the word into rows (using regex tokenize) and the see if the 9th row is a " "

LordNeilLord

@andyuttley

Much simpler than my method!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703