You are viewing limited content. For full access, please sign in.

Question

Question

Creating Folder Based on Attachment Name - How do I remove the extension?

asked on July 16, 2018

I have a quick and easy process for users to upload supplier documents:

When these files save to Laserfiche, they're saved in a subfolder using the same name as the transmittal:

It saves with the PDF extension. How can I avoid that?

0 0

Answer

SELECTED ANSWER
replied on July 16, 2018 Show version history

I did it! I created two hidden fields:

1. "transCopy" that actually grabs the name of the uploaded transmittal name and

2. "subfolder" which contains a formula that removes the .pdf

 

As recommended by Karina, I changed my formula to:

=LEFT(Field, SUB(LEN(Field), 4))

My end result:

0 0
replied on July 16, 2018

Hi Gloria,

What happens if there are extra periods in the name of the file? Below is a slightly different approach that trims the last 4 characters (the period and the 3 characters of the extension)

=LEFT(Field, SUB(LEN(Field), 4))

0 0
replied on July 16, 2018

Thank you! Very helpful. Used that instead.

0 0

Replies

replied on July 16, 2018

Hi

You can use Pattern Matching, something like this “((?:\w+\s*)+)” maybe someone can make this more efficient.

Hope this work.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.