Problem in Regex Split

[Jyotendra]

Hi,

I have a column with a values having dates, time and string… screenshot below.

I can split this value into different columns using the regex split node using below regex

(\d+/\d+/\d+)(\D+)(\d+:\d+\s[a|p]m)([\s]-[\s])([^:]+):(.)|(.)

However, if I am getting data like below… not only does this regex fails but all other variation of the regex as well.

I tried using \s? as well but it failed. while the difference in both of the data is a ‘space’ in time stamp.

What am I missing?

[Jyotendra]

This is resolved. There was some unidentified texts “‚ÄØ” which was not visible in KNIME table but was being seen when data was opened in excel. replacing this text with a space solved the problem.

[takbb]

Hi @Jyotendra , I’m glad to hear you managed to resolve your problem, and thanks for letting us know you managed to solve it. Please mark your latest post as “solution” so that it shows as resolved.