Hi,
Is there any way to remove Leading and trailing alphabets (A-Z & a-z) within the string of any length .
Thanks.
Solved! Go to Solution.
Hi @praneshsapmm,
You could use a regex replace function:
REGEX_Replace([Data], '^[a-z]*(.*?)[a-z]*$', '$1')
Kind regards,
Jonathan
Not sure what you mean exactly by "leading and trailing alphabets", but perhaps this post on stackoverflow would contain the regex pattern you are seeking?
This works . THankyou very much .
Also can you let me know the regex function to remove :
1. Leading Alphabets
2. Trailing Alphabets.
Thanks
Hi @praneshsapmm,
The function above would remove leading and trailing alphabets, did you want a formula to do each on separately or did you mean something else?
Kind regards,
Jonathan