Forum Discussion

Alisea_MI's avatar
Alisea_MI
Resolver II
5 years ago
Solved

Conditional Substring

Hi,

 

I need to set up a conditional column, which looks at the first three characters in a text column and if the third character is " ", it should return the first two characters, else "null".

Example: ZW BY 34 should return ZW.  SSRS 43 YT should return "null". 

 

Would be grateful for any input on this!

Need Help
  • DataZoe's avatar
    DataZoe
    5 years ago

    Alisea_MI You could try a calculated column such as 

    Substring = 
    IF (
    MID ( Customer[Name] , 3, 1 ) = " ",
    LEFT ( Customer[Name] , 2 ),
    BLANK ()
    )

2 Replies

  • DataZoe's avatar
    DataZoe
    Microsoft Employee
    5 years ago

    Alisea_MI You could try a calculated column such as 

    Substring = 
    IF (
    MID ( Customer[Name] , 3, 1 ) = " ",
    LEFT ( Customer[Name] , 2 ),
    BLANK ()
    )