Sam P Posted December 4, 2023 Share Posted December 4, 2023 Hi, is there / could there be the equivalent of the =LEFT(text, [num_chars]) Excel formula that could return a fixed number of characters from an Intelligent Capture response? I'm trying to find the best way to get JSmith from John Smith. I guess it could also include =RIGHT as an alternative option. Thanks Link to comment Share on other sites More sharing options...
Steve Giller Posted December 4, 2023 Share Posted December 4, 2023 Where are you intending to use this? Link to comment Share on other sites More sharing options...
Sam P Posted December 4, 2023 Author Share Posted December 4, 2023 Hi @Steve Giller thanks, I need to sneak it in before the Hornbill Automation node to generate firstinitial+surname before it goes off and creates the next AD account. Is there a different / better way of doing it? Link to comment Share on other sites More sharing options...
Steve Giller Posted December 4, 2023 Share Posted December 4, 2023 There is a String Utilities node, probably Regex Substring is the best option for this use case: Link to comment Share on other sites More sharing options...
Sam P Posted December 5, 2023 Author Share Posted December 5, 2023 @Steve Giller thanks I'll take a look Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now