Hi,
Can I split text and numeric data as mentioned in below screen. I need only text data as highlighted in yellow color.
Thanks,
Hi @Srawat
You could use the following formula to remove any number values and ANY instance of /
Replacechar([Particular],'0123456789/','')
@Srawat,
Please see below :
Attached the workflow,
Regards
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.
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"
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")
