Forum Discussion

DerekP1971's avatar
DerekP1971
New Member
6 years ago

Token Eof expected

I keep erroring out on this code and it keeps highlighting the Paren I am not a programmer so I am struggling to understand what is wrong with this code.   Find Left Paren and set LEN to 10= if(fin...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi DerekP1971 ,

 

If you want to get the ten chars after the left token, we can create a calculated column using following formula:

 

Find Left Paren and set LEN to 10 =
VAR location =
    FIND ( UNICHAR ( 40 ), [NCFM_PROB_DESC_TXT],, -1 )
RETURN
    IF (
        location > 0,
        LEFT (
            RIGHT ( [NCFM_PROB_DESC_TXT], LEN ( [NCFM_PROB_DESC_TXT] ) - location ),
            10
        ),
        ""
    )

 

 

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.