Replace comma with tab

Hi, string from Output Datatable activity
EG. Staff Name, Staff No
ABC,123

would like to replace the “,” with tab to create a string that is something like this
Staff Name Staff No
ABC 123

replacing with space does not work,as alignment would be off
I’ve tried replace with “vbtab” but it just writes “vbtab” instead of sending tab

@inyourgravity

Try this:

Str = “Staff Name, Staff No”

Str.replace(",",vbtab)

2 Likes

@inyourgravity yes it is possible by string manipulation,once you store that string in a variable use assign activity and in value place like strvariable.replace(","," ") it’s gonna give you the output as per your required output.