Split text (string)

I​ want​ split​ value​ in​ ColumnG​ (split​ /)​ as​ below

datatest.xlsx (8.9 KB)
testtt.xaml (20.0 KB)

But output not correct as below.

I​ want​ output​ toEffDate =23​, toEffMonth = 07​ , toEffYear = 2021

Please guide me for solve it.

1 Like

You can use this expression

Use a assign activity inside a for each row activity with dt as input
In assign
Str_toEffDate = Split(row(“ColumnG”).ToString.Trim,”/“)(0).ToString

Str_toEffmonth = Split(row(“ColumnG”).ToString.Trim,”/“)(1).ToString

Str_toEffyear = Split(row(“ColumnG”).ToString.Trim,”/“)(2).ToString

Cheers @fairymemay

1 Like

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