Hi,
Can I split text and numeric data as mentioned in below screen. I need only text data as highlighted in yellow color.
Thanks,
Solved! Go to Solution.
Hi @Srawat
You could use the following formula to remove any number values and ANY instance of /
Replacechar([Particular],'0123456789/','')
Thank you so much! perfect solution.
Can we remove highlighted red color items as well from the lines? or any specific thing in one go. Please advise.
Thanks,
Perfect Solution. It works. Thank you so much.
Hi,
I am getting some other issue in splitting the data. I used your below formula.
Output
data available in Input is.
Want to get only. "ECore"
Thanks,
Please try with the attached solution.
REGEX_Replace([Field1],"(.+?)(?: +- +| +)((?:0?1|Jan(?:uary)?)|(?:0?2|Feb(?:ruary)?)|(?:0?3|Mar(?:ch)?)|(?:0?4|Apr(?:il)?)|(?:0?5|May)|(?:0?6|Jun(?:e)?)|(?:0?7|Jul(?:y)?)|(?:0?8|Aug(?:ust)?)|(?:0?9|Sep(?:tember)?)|(?:10|Oct(?:ober)?)|(?:11|Nov(?:ember)?)|(?:12|Dec(?:ember)?))(?: |\/|-|\.|)([0-9]+)?","$1")