Today I come to you to ask for help. I am trying to read a CSV file that uses TAB as delimiter and convert it as data table. UiPath don’t recognize TAB as delimiter. I want to change the TAB for “,” using a power shell option.
The Assign activity uses the expression csvText.Replace(ControlChars.Tab, ","). You can also install the Workflow Manager Activities package and find a special Replace String activity to do the same.
And then running the script with the activity UiPath.Script.Activities.PowerShell.RunPowerShellScript.
Using the Invoke PowerShell option was complicated due to the fact that the delimiter “`t” is not valid for Char but could be more simple if the delimiter is just a character.