How to separate this field into 3 fields

[#1]

Hi all, appreciate any help here!!

The data in the field looks like this:

"Brick Factory - John Smith - 1234"

Am hoping to split each component into its own field in the load statement using the hyphen characters as separators I guess...

Cheers J

[arulsettu]

try this

load

SubField('Brick Factory - John Smith - 1234','-',1) as company,

SubField('Brick Factory - John Smith - 1234','-',2) as name

SubField('Brick Factory - John Smith - 1234','-',3) as id

replace with your filed

[avinashelite]

Try like this

SubField(Field_name,'-',1) as Company,

SubField(Field_name,'-',2)  as Name

NOTE: In order to implement this logic your data inflow should be maintained in the same order