Split Column DAX Before Space

[cyborgandy]

Hi All,

I have below column in my dataset, I want to use delimiter DAX to give me all the left value result before the space however I have written a dax but as I have few entries which doesnt have space in the value its throwing me error " " not found in the column, below is the column format, can someone please help.

Full Post Code

RG24 8YB

BT4 1AF

M12 6LB

60323

50170

3369

60327

75011

WC1H 8HA

G71 5PW

D02 HW77

VLT 1455

D02 YA40

[mlsx4]

Hi @cyborgandy 

Try this code... Otherwise, you will miss some values when there's no space

New Column = 

IF(CONTAINSSTRING([Full post code]," "),
    LEFT(
        [Full Post Code], 
        SEARCH(" ", [Full Post Code], 1, LEN([Full Post Code])) - 1
),
[Full post code]
)

Kind regards

[eliasayyy · Accepted solution]

New Column =
IFERROR(
    LEFT(
        [Full Post Code], 
        SEARCH(" ", [Full Post Code], 1, LEN([Full Post Code])) - 1
    ), 
    [Full Post Code]
)