change the value from String to '2018/01'

Hello, please give me a hand!

How can I change the value from ‘20180116’ to ‘2018/01’?

‘20180116’ is STRING.

image

Hey @JimmyPark,

easiest way would be using a String-Manipulation-Node and within this node the replace function.

image

Kind regards,

Patrick.

How about this:
you convert it into a Date/time with the pattern yyyyMMdd
And afterwards you use the Date/Time to String with the pattern yyyy’/'MM

Cheers, Iris