SParam

Get a substring of a string.

Syntax

SParam(Param, Split, Index)
Parameters of SParam:
Param:Necessary parameter.Character string type.Param is an expression of a string
Split:Necessary parameter.Character string type.
Index:Necessary parameter.Number string type.

Description

SParam returns a substring starting from Param[Start_Postion] to Param[End_Postion] that Start_Postion at index value of the specified Index Split substring, and End_Postion at index value of the specified Index-1 Split substring

Example

SParam('China;United States;Russia;U.K.',';',1),Return 'United States'.

 

 

 

Return to DBPut data converter document

Download DBPut data converter software