On a transaction saved search. Can you create a formula the uses created from field, but strips out everything before the "#" in the results

AI generated answer (using internal Slack threads):

Yes, you can create a formula in a transaction saved search that uses the 'created from' field and strips out everything before the "#" in the results. You can use the

SUBSTR

function in your formula to achieve this. The

SUBSTR

function allows you to extract a substring from a string. It takes three parameters: the string, the start position, and the length of the substring. In your case, you would use the

INSTR

function to find the position of the "#" character in the 'created from' field, and then use that position as the start position for the

SUBSTR

function. Here is an example of how you might write the formula:

SQL
SUBSTR({createdfrom}, INSTR({createdfrom}, '#')+1)

This formula will return the substring of the 'createdfrom' field that starts at the position immediately after the "#" character and goes to the end of the string. Please note that the field names and functions used in this formula are case-sensitive and must be written exactly as shown. Also, this formula assumes that there is only one "#" character in the 'createdfrom' field. If there are multiple "#" characters, the formula will return the substring starting from the first "#" character. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******