0

I have a sharepoint online library where I have some files which are names liked: AG_11-08-2021 or CE_11-08-2021 etc or FLASH_08-11-2022. It is always the same type of name, the first letters are here to define the type of event.

I just wonder, how can I "extract" the content of only the text to a calculated formula ?

I have my title column which indicates the name (like CE_11-08-2021) and I would like the calculated formula to show CE in this case.

I tried using a formula like: =LEFT([Title]",INT(FIND("_",[Title])-1)) but it says error all the time, whereas I though it would be working.

Is there anyone who have an idea ?

Thanks in advance for your previous help !

1 Answer 1

0

Use below formula in SharePoint library

=IFERROR((LEFT([Title],(FIND("_",[Title])-1))),[Title])

Refer the below screen shot of SharePoint list.

enter image description here

3
  • Thanks a lot for your quick reply. It is amazing to see it working on your side. But, it is maybe a mistery, everytime I create a new column with calculated value, I copy paste your function and when I want to save, it says "syntax error or not supported". We have a O365 licence with sharepoint online, same as you from what I can see on your screenshot. Do you have any idea what may be the issue ? Thanks again for your assistance.
    – Alejandroo
    Commented Feb 16, 2022 at 12:52
  • Ahh ! I know what the issue is. I am based in Canada and using French as a language. And in France (or French speaking countries), we do not have to use "," but ";" instead. I changed it and it works perfectly ! Sorry for that and thanks again for your precious Help Rajat !
    – Alejandroo
    Commented Feb 16, 2022 at 13:08
  • Please accept as answer and upvote it as it is working. this is how we help each other. Commented Feb 16, 2022 at 14:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.