Is there a way in Anaplan from a TEXT to understand if it contains non-numeric characters (alphabetical letters and symbols)?
Thank you!
Hello @JoanaNdreu
You can use the find function.Find function
@JoanaNdreu : if you are interested only in finding if a text contains any non-numeric characters, you can use the function VALUE() β¦
If value(line-item_txt) *0 = 0 then line-item contains only numeric else contains some other chars.
hope it helps
Alex
Hi ,
Yes, You can use functions like FINDITEM, CODE, VALUE, or compare the original text with TEXT(VALUE(Text)) to identify whether a text string contains non-numeric characters.
TEXT(VALUE(Text))
However, Anaplan does not have a built-in regex function, so detecting letters or symbols usually requires a custom validation formula.
Thanks!
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a listβ¦
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
