Add hyphnes to strings in a specific order

KNIME Analytics Platform
1

Hello,

I have the following numbers,

12345
1234567

I want to convert them to

1-234-5
1-234-567

any suggestions?

Thank you

2

Hello @kanishka271
‘String Manipulation’ node:

join(
	substr($yourColName$, 0, 1)
	, "-"
	, substr($yourColName$, 1, 3)
	, "-"
	, substr($yourColName$, 4, length($yourColName$) )
	)

BR

4 Likes
3

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