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 !
Solved! Go to Solution.
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
iif (substring ([your_string], n-1, 1) = " "; 1; 0)
Oh of course .. Thank you 🙂
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 " "