Extracting the Date in a File

@KamenRider I used a RegEx tool's Parse function with this expression: ^\d{10}\_(\d{8}) then used a Formula tool and applied your expression to the field the RegEx tool created: DateTimeParse(REGEX_Replace([RegExOut1], '[^\d{8}]', ''),'%Y%m%d').

binu_acs

@KamenRider One way of doing this

Regex_Date_070923.yxmd

Prometheus

@KamenRider @binu_acs

Oh yes. This is great because it creates a nested expression to parse and create the date in one.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703