String manipulation syntax

KNIME Analytics Platform
1

Hello, may I ask you for advice in string manipulation node,
for a syntax to get from string [P1-18] to P01 18 ??
thank you very much in advance!!

3

hi @Averin7777
I suggest you use this expression in the String Manipulation node

string(
	substr($string$,1,1)+
	padLeft(regexReplace($string$,"^.*?(\\d+).*$","$1"),2,"0")+
	" "+
	padLeft(regexReplace($string$,"^.*\\-(\\d+).*$","$1"),2,"0")
)

Results
immagine

4 Likes
4

Hello, thank you soo much!! I really admire guys like who know this composed syntax :+1: :+1:
but could you please help me again :man_facepalming:
I need get from [FEB18] to Feb-18 !! if possible?
Thank you!!

5 
string(
	capitalize(substr($string$,1,3))+
	"-"+
	padLeft(regexReplace($string$,"^.*?(\\d+).*$","$1"),2,"0")
)
2 Likes
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.