Forum Discussion
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) ...
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 )
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.
tamerj1 plz reply
Bill to Customer 2 = VAR String = dimCustomer[Bill to Customer] VAR Items = SUBSTITUTE ( SUBSTITUTE ( String, "(", "|" ), ")", "|" ) RETURN COALESCE ( PATHITEM ( Items, 2 ), "N/A" )Still N/A not displayed