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
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
Thanks for this post..it was useful in one of my requirement
ReplyDeleteThank you for sharing the knowledge. It's useful for what I need to do.
ReplyDeleteVery good info
ReplyDelete