Hi,
Is there any way to remove Leading and trailing alphabets (A-Z & a-z) within the string of any length .
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
You could use a regex replace function:
REGEX_Replace([Data], '^[a-z]*(.*?)[a-z]*$', '$1')
Also attached an example of how it would work!
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?
https://stackoverflow.com/questions/61544656/avoid-leading-and-trailing-spaces-on-alphanumeric-string
Hi @Jonathan-Sherman
This works . THankyou very much .
Also can you let me know the regex function to remove :
1. Leading Alphabets
2. Trailing Alphabets.
Thanks
