How to do it...

To implement this recipe, perform the following steps:

1. Create the following columns:

Color = 
    VAR __find = "Color: "
    VAR __pos = SEARCH(__find,'R09_Table'[Column1],,BLANK())
    VAR __semipos = SEARCH(";",'R09_Table'[Column1],__pos,BLANK())
    VAR __semipos1 = IF(ISBLANK(__semipos),LEN('R09_Table'[Column1]) + 1,__semipos)
    VAR __len = LEN(__find)
    VAR __start = __pos + __len
RETURN
    IF(
        ISBLANK(__pos),
        BLANK(),
        MID('R09_Table'[Column1],__start, __semipos1 - __start)
    )

Name = 
    VAR __find = "Name: "
    VAR __pos = SEARCH(__find,'R09_Table'[Column1])
    VAR __semipos = SEARCH(";",'R09_Table'[Column1],__pos,BLANK())
    VAR __semipos1 = IF(ISBLANK(__semipos),LEN('R09_Table'[Column1]) + 1,__semipos)
    VAR __len = LEN(__find)
    VAR __start = __pos + __len
RETURN
    IF(
        ISBLANK(__pos),
        BLANK(),
        MID('R09_Table'[Column1],__start, __semipos1 - __start)
    )

Number = 
    VAR __find = "Number: "
    VAR __pos = SEARCH(__find,'R09_Table'[Column1])
    VAR __semipos = SEARCH(";",'R09_Table'[Column1],__pos,BLANK())
    VAR __semipos1 = IF(ISBLANK(__semipos),LEN('R09_Table'[Column1]) + 1,__semipos)
    VAR __len = LEN(__find)
    VAR __start = __pos + __len
RETURN
    IF(
        ISBLANK(__pos),
        BLANK(),
        MID('R09_Table'[Column1],__start, __semipos1 - __start)
    )