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) ...
Use MID func.
=MID([ColumnName], FIND("(", [ColumnName], 1, LEN([ColumnName]), 0) + 1,
FIND(")", [ColumnName], 1, LEN([ColumnName]), 0) - FIND("(", [ColumnName], 1, LEN([ColumnName]), 0) - 1)
replace col name with actual column name .
Instead of 0 only u used len function then again using 0 how u used 0 ?
Here is the explanation of the formula:
- FIND("(", [ColumnName], 1, LEN([ColumnName]), 0) + 1 - It finds the first character after the opening bracket.
- FIND(")", [ColumnName], 1, LEN([ColumnName]), 0) - FIND("(", [ColumnName], 1, LEN([ColumnName]), 0) - 1 - It calculates the number of characters to extract.
- MID([ColumnName], ..., ...) - This function will then extract the required number of characters starting from the specified position.
Also, know the details of the Find function.
refer: https://learn.microsoft.com/en-us/dax/find-function-dax
Bro for find function only 4 input but u extra added 0 also .find ("(", column name , 1 ( starting position), len ( not found value ))
