This is in ServiceNow. If you do not have experience with this platform please do not bid.
I am importing data from a sql database with a field that has a string of information such as the following:
On the table this data is going to, I have a field labeled System and a field labeled Groupname.
In the transform map, I am wanting to parse out the system, and the group name so that they can go into their own respective fields.
Obviously the system and groupnames will be different on the majority of entries, so I was looking to parse the system by starting left and saying system=string UP TO the first "/". And do the same thing for group name, but look from the right. However, the data is inconsistent for the character before the groupname. Sometimes it is "/" and sometimes it is "\". So I would like to look from end of string on the right (going left), for the first "/" OR "\", and the text after that character would be the groupname.