Hi,
I could split a source field using calculation option in syndicator.
However it is not necessary to save the field in Main table but to create it on the fly before populating destination field because it is not required to unnecessarily save all these temproary calculated field in database.
Appreciate your valued input how to create temproary field on the fly w/o saving them in repository.
-Reo