Monday, April 22, 2013

Spliting String using calculated Field


To Split a String based on delimiter.This requirement can be achieved with out using Siebel scripting.


Create two Calculated field to split the string one for left side of the delimiter and other 
for right side of the delimiter.

Left Description: Left([Description],InStr([Description],"/")-1)
Right Description: Right([Description],(Len([Description])-InStr([Description],"/"))) 

[Description Field] Stores the values BRILLIANT SILVER M ,RED

After evaluating the above stated calculated expression.

Left Description:  BRILLIANT SILVER M
Right Description: RED


1 comment:

  1. Thanks for this was useful in one of my requirement