I need help asap... been struggling with this for past 3 hours!!

KNIME Analytics Platform
1

I was looking at previous answers to this but it does not work on mine. I need to change a string in a column from “22yrs 6mon” to months only. Please let me know how to do this? It is very urgent!!

2

You could use a Regex in the Expressio node

parse_int(regex_extract($["duration_txt"], "(\\d+)(?=mon)", 1))

RegEx Split String - KNIME Forum (89900).knwf (50.2 KB)

image
image1243×862 54.1 KB

3 Likes
3

Below Simple workflows gives the output you requested. Can you check this?

image
image871×668 20.3 KB

Expression Used:

parse_int(first_chars($["Date String"],2))*12 + parse_int(substring($["Date String"],7,1))
6 Likes