Breaking data into two (or more) strings...

Hello

I am new here.

:blink:

I have data in a field like this:
{house, post code}
house1, postcode1
house2, postcode2
house3, postcode3
house4, postcode4

and I want to load it to a new DB that has house and post code as SEPARATE fields

How can I separate this data and load it to two separate fields?

Paul

Hi

You can use splitter transformation for that.
You may also need trimming spaces from the second field

Mike