Excel mid formula excel equivalent
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
i have a column with text such as 1010000001010010.
i need to determine whether the 10th value is 1 and then use that for a conditional statement. What can i use to get this?
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Usamah22,
this function in a formula tool will allow you to extract the 10th character from your string, which you can then use in a conditional statement.
Substring([YourStringField],9,1)
Notice 9 to indicate the 10th character because the start of the substring is 0-based (first character is position 0).
Hope this helps!
Giuseppe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Usamah22,
Using the formula:
IF Substring(ToString([String]),9,1) = '1' THEN 'True' ELSE 'False' ENDIF
This will return "True" if the 10th character = 1 and "False" if it does not.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
