Skip to Content
0
Former Member
Nov 10, 2008 at 10:03 AM

count the position of substring

15 Views

Hi,

Is there any way to count the position of the substring in a string?

I have a requirement where the string I419II/I423II/ZCTOII/I704II/S415II/J001II/ZCSCDII/ZCSCOII has to be split and put into 2 fields function and department.The function field should have 40 or less than 40(near to 40) characters length where '/' should be the last character and the remaining part of the string should be put into department field.