i have a requirement where I have to split a field into 2 and map it to two different fields.
For example, They are sending a field…which has David, Richard value.
They are sending (,) in the field…and I need to send David to one field and Richard to another field.
So, I have to map value before (,) to one field and value after(,) to another field.
Can you guys please help me to write the logic to split.