I am struggling to apply both a Trim and Title Case to a column in my datatable. I am using a For Each Row activity and have successfully trimmed the writespaces out using the following Assign activity:
row(“First Name”) = row(“First Name”).ToString.Trim
However, now I am trying to change the result to Title Case so that I can properly join on another datatable. I was trying to use the following, but I am not sure how to properly use it based on my trimmed data.
Can anyone point me in the right direction? Is there any way to combine these steps or do they need to be done separately?