Want to Split text and numberic

[Srawat]

Hi,

Can I split text and numeric data as mentioned in below screen. I need only text data as highlighted in yellow color.

Thanks,

[davidskaife · Accepted solution]

Hi @Srawat 

You could use the following formula to remove any number values and ANY instance of /

Replacechar([Particular],'0123456789/','')

[messi007 · Accepted solution]

@Srawat,

Please see below :

Attached the workflow,

Regards

[Srawat]

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,

[messi007 · Accepted solution]

@Srawat,

Please see below :

Regards

[Srawat]

Perfect Solution. It works. Thank you so much.

[Srawat]

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,

[NeoInfiniTech]

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")