How to keep only the first character in an excel table?

Help Studio
5

Hi @Snow

Regex expression

OutData = System.Text.RegularExpressions.Regex.Match(CurrentRow("Grade").ToString,"^\d+(?=;)").ToString

Check out the XAML file

KeepOnlyFirstCharInExcel.xaml (11.7 KB)

Output

KeepOnlyFirstCharInExcel.xlsx (7.2 KB)

image

Regards
Gokul