ReplaceByListSep

Replaces a given placeholder by the system's list separator.

Compatibility

Available as of IDEA version 9.0

Syntax

ReplaceByListSep(sourceString as String, placeholder as String)

Parameters

sourceString

The source string.

placeholder

The string to be replaced by the system's list separator.

Example

Dim SimpleCommands As Object 
Dim result As String 
Dim sourceStringAs String 

Sub Main 
	Set SimpleCommands = SmartContext.MacroCommands.SimpleCommands 
	sourceString = "@between(account_number# 1000# 9999)" 

	'Return a string where the placeholder is replaced by the system's list separator. 
	eqn =SimpleCommands.ReplaceByListSep(sourceString, "#") 

	'Do something with equation. 
	... 

	'Release object. 
	Set SimpleCommands = Nothing 
End Sub

Copy example