Paginated Report Power Bi expression need to trim value

[Sarah1687]

I would like help with adding an expression for trimming a field value in a paginated report. The field consists of a first name, last name and number inside of it. I would only like to show the first and last name, but I am not sure how to . I have been trying to use LEN, LEFT, and RIGHT, but I'm not sure how to use it right. Below is an example of a value

"Sarah Lipton 4568875312" < This would be displayed when selecting the field name "Personnel".

"Sarah Lipton" < I would like it to display as this.

All of the phone numbers are the same length of 10 characters.

Please help me add an expression to trim the field content.

I tried =Left(Fields!Personnel.Value, Len(Fields!Personnel.Value) - InStr(Fields!Personnel.Value, "4"))

[Anonymous · Accepted solution]

Hi @Sarah1687 ,

Based on your description, the phone number is 10 characters and the phone number may not start with 4, so I would suggest you try that:

=Left（Fields！Personnel.Value， Len（Fields！Personnel.Value） - 10）

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.