Answered

removing extension from the file name

(0) Share

Report

Posted on by Rohit_RC

Hello,

I've a requirement wherein I need to remove the extension (eg. ".json",".css", ".svg" etc) from the file name
some of the file name contains dot(.)

Ex : I have a file name as - filename.c_en.json => I need filename.c_en
how can I achieve this, I don't want to use flow
can this be achieved using Split() along with First(), Last(),..etc ?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,554 Most Valuable Professional on at

Like (5)

Report
Copy link

Link copied!
Hi @Rohit_RC ,

Try this

Left( YourFileName, Len(YourFileName) - Len( Last( Split( YourFileName, "." ) ).Result ) - 1 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Rohit_RC 20 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for the help!!
this formula works perfectly

Was this reply helpful? Yes No