Monday, April 22, 2013

Spliting String using calculated Field

Requirement:

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

Approach:

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],"/"))) 

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

After evaluating the above stated calculated expression.

Left Description:  BRILLIANT SILVER M
Right Description: RED






 






3 comments:

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

    ReplyDelete
  2. Thank you for sharing the knowledge. It's useful for what I need to do.

    ReplyDelete