Load field only up to comma

[jeckstein]

I have  a field a table that looks like this.

ID	Type
300	Jim,Dave,Scott
500	Ron,Betty,Jeff
600	Sara,Nick,Nick

When loading into Qlik I need only the charteres to the left of the first comma in the type column. The result should look like this.

ID	Type
300	Jim
500	Ron
600	Sara

Any help??

Thanks in advanced.

[sunny_talwar]

May be like this:

LOAD ID,

         SubField(Type, ',', 1) as Type

FROM ....