Extrat text from long text without trucante word

[Anonymous]

Hi Dears,

I need to display around the first 600 characters of a long text field but the left function truncate the word sometimes.

How can I get left part of a long text but get the last full word after a certain position.

Best regards,

Augusto

[sturlaws · Accepted solution]

hi @Anonymous 

you can try something like this

someColumn =
VAR _currentString =
    CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
    RIGHT ( _currentString; LEN ( _currentString ) - 600 )
VAR _firstSpace =
    SEARCH ( " "; _rightPartOfString ) - 1
RETURN
    LEFT ( _currentString; 600 + _firstSpace )

This code expands the left function to the first space after character number 600.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[Anonymous]

Hi Surla,

I'm facing a challange yet. When the long text has less than 600 characters.

Could you please help me!

Thanks,

Augusto

[sturlaws]

someColumn =
VAR _currentString =
    CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
    RIGHT ( _currentString; LEN ( _currentString ) - 600 )
VAR _firstSpace =
    SEARCH ( " "; _rightPartOfString ) - 1
RETURN
    IF (
        LEN ( _currentstring ) <= 600;
        _currentstring;
        LEFT ( _currentString; 600 + _firstSpace )
    )

[Anonymous]

Hi Dear Sturla,

Last night I tried the same approach as you posted above and got trhe same error message.

"An argument of function 'RIGHT' has the wrong data type or has an invalid value."

Thanks for your attention,

Augusto

[sturlaws]

try this

someColumn =
VAR _currentString =
    CALCULATE ( SELECTEDVALUE ( 'Table1'[Column1] ) )
VAR _rightPartOfString =
    IF (
        LEN ( _curentstring ) <= 600;
        BLANK ();
        RIGHT ( _currentString; LEN ( _currentString ) - 600 )
    )
VAR _firstSpace =
    IF ( ISBLANK ( _rightPartOfString ); 0; SEARCH ( " "; _rightPartOfString ) - 1 )
RETURN
    IF (
        LEN ( _currentstring ) <= 600;
        _currentstring;
        LEFT ( _currentString; 600 + _firstSpace )
    )

[Anonymous]

Hi Dear Sturla,

You save me a lot of effort to get to a measure likes you provided.

Your solution works perfectly.

Thanks a lot. 

Augusto