Data Splitting

[New-here1]

Hi Y'all

In one field I have a breakdown of various task numbers. There are two types of numbers; a number (for example 500) which relates to the main task and a number (for example 500.1, 500.2, ect) which relates to the sub task.

I would like to split these out so I can have one column that shows the main task number, and a column that show the sub task number. 

What is the best way to do this please?

Thank you

[Chanty4u]

Try this ways 

LOAD

    TaskNumber as MainTaskNumber,

    Subfield(TaskNumber, '.') as SubTaskNumber

FROM YourDataSource;

Or

LOAD

    TaskNumber as MainTaskNumber,

    Right(TaskNumber, Len(TaskNumber) - Index(TaskNumber, '.')) as SubTaskNumber

FROM YourDataSource;