Recipe:
When text changes to splice value from start to end and push to column
When a text column changes you want it push the same name but excluding words that are auto generated by the system.
Based on the numbers you enter in the start and end selections in the recipe, you can exclude words from the start/end.(count the characters).
For example, you have the auto generated words and numbers as follows:123-monday.com
You now wish that when this auto generated text to have the "123-" and the ".com" removed and pushed to another column (the last column selection in the recipe).
To do this the automation will be as follows in the start and end section of the recipe:
start= 4 (123- has 4 characters)
end= -4 (.com also has 4 characters as it includes the "period", dot com)
Please ensure the end number in the recipe has a negative figure in there, for example "-4".
You can also have a positive number at the end, for example if the start was 4 and the end was 6:
end= 4
This would remove the 5th and 6th character from the left side of the data.
Comments
0 comments
Please sign in to leave a comment.