Extracting first row within the row from a column

[Anonymous]

Hi,

How to load data from a column when we have multiple rows with in a row.

Example:

Header 1
Name
Steven Joseph Cruz
Alex Yoh Chang Yan
Screw Saw

Output should be:

Header 1
Name
Steven
Alex
Screw

Please help me on this example.

[tresesco]

Use chr(10) for new line like:

LOAD

SubField(Name,chr(10),1) as FirstName

FROM <>;

PFA.

[Anonymous]

Hi,

It worked well.

Many thanks.

[tresesco]

Please close the thread then, by marking the right post as answered. It would help others as well.