Convert a space seperated stringList to Tab delimited

, ,
1

Doing a get from a database and the results are returned in a stringList with a single space as the seperator. Would like to replace the single space with a tab delimitor.

Problem I am having is working out the correct regular expression to use in the pub.string:replace

searchString = \s - this seems to be fine
replaceString = \t - not so fine and the single space is replaced with a t
useRegex = true

Any help would be greatly appreciated.

Bryan

Running Developer 6.5

2

When setting the replaceString field, right-click and select “Use larger editor”. In the editor, type the tab (not \t).

3

Thanks Rob. Twas as simple as that.