Forum Discussion

Karthikgayathri's avatar
Karthikgayathri
Helper I
3 years ago

undefined

rubayatyasmin   i need output as text without the bracket  ex : Head Office   I used to write the code  Right ( dim( customer) , search("(" , dim( customer) 1, len ( dim( customer )+1)-1)  ...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Karthikgayathri 
Please try

Bill to Customer 2 =
SUBSTITUTE ( SUBSTITUTE ( dimCustomer[Bill to Customer], ")", "" ), "(", "" )
  • Karthikgayathri's avatar
    Karthikgayathri
    Helper I
    3 years ago

     

     for your query above image 

    output . I need only head office without bracket 

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Karthikgayathri 
      Sorry. I misunderstood the requirement. Please try 

      Bill to Customer 2 = 
VAR String = dimCustomer[Bill to Customer]
VAR Items = SUBSTITUTE ( SUBSTITUTE ( String, "(", "|" ), ")", "|" )
RETURN
    PATHITEM ( Items, 2 )
      • Karthikgayathri's avatar
        Karthikgayathri
        Helper I
        3 years ago

          In 2 nd image - see the input 

               1 st image I got the same output but instead of N/A showing blank .in output both N/A and head office need to display.