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

Karthikgayathri 

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

    Still N/A not displayed

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Karthikgayathri 

      Try

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

          ok I will try your code . Above image see my code and my output. in output head office showing but in N/A only showing A alone wht is the issue in my code plz tell .