How to Split a field based on on delimiter using A script

      How to Split a field based on on delimiter using A script

      Hi there

      I need to split a field into multiple separate fields based on a semi-colon (;) delimiter.

      Unfortunately the database I am connecting to holds ledger balances for each period in a single field with ";" delimiters. Hence I would like to write a script (Java? Groovy? Any suggestions?) that would take a field called "periodbal" e.g 123.34;234;18769.36 etc. and split into separate records.

      Period 1 would be 123.34 in above example

      Period 2 would be 234 etc.

      Does anyone out there have the relevant code that coukld simply be pasted into the filed transform box in the ETL tool with Jedox Suite? I have read there is a Split function in Java but I am not sure how to write the specific code/script for it to work in my example.

      Any help much appreciated. ?(