Find Last Occurrence Of Character In String

Hi @Bryant_Chang

To Solve your issue, please use below formula:
{{substring(2.Input Text; 0; sum(length(2.Input Text); -1; “-” + length(last(split(2.Input Text; space)))))}}…

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!

3 Likes