String: Extract two middle characters

[NachoArg]

Hi, 

I have the following string: "210617". That is 21= 2021, 06= Jun and 17=day.

Which is the formula to extract "06" ?

I used right with 2 in order to get the day and I used left with 2 in order to get the year, but I can´t find the formula to extract "06"

Regards,

Igancio 

[mceleavey · Accepted solution]

@NachoArg ,

You can do this in a simple formula:

substring(tostring([Text]),2,2)

Hope this helps,

M.

[shreyanshrathod]

@NachoArg , you could use substring('210617',2,2) OR you could use Regex_parse.

Regards,

Shreyansh

[apathetichell]

Since you are probably running datetime calculations on it - why not just convert it to a date via datetimeparse("20"+tostring([field1]),"%Y%m%d")

then you can use datetimeformat([date],"%m") to get the month and do all those fun datetime calculations...

[NachoArg]

Thank you both !!   😊

Actually I was trying something like  +mid as I use in Excel.

[mceleavey]