Hello, How can I splits Days column into 5 different columns as below Thank You DaysMonTueWedThrFriMM MTMT MTWMTW MTWRMTWR MTWRFMTWRF

Split words from a String

Hello,

How can I splits Days column into 5 different columns as below

Thank You

Regex

@ankit0412 one way of doing this

You need to split the word into rows and then cross tab them to get back the tabular data. Attached is the workflow demonstrating the same.

@ankit0412
How about we directly split the string to 5 columns.

@ankit0412 one way of doing this

@ankit0412 another way would be using the formula tool and if contains e.g

IIF(Contains([Days], "M"), "M", null())

Screenshot 2025-08-11 114352.png