Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
5 subscribers
Views
1385 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Hi all, I'm using RDBMS Blob Utility plug-in that converts an image int
phanibabuk
over 8 years ago
Hi all,
I'm using RDBMS Blob Utility plug-in that converts an image into an attachment.
It worked fine.
However, there is a "0" getting appended at the end of each file.
How can I remove the last character of the file name being created.
Eg:- Hello World.pdf is getting stored at Hello World.pdf0
ReadDoc.doc is getting stored as ReadDoc.doc0
I wanted to remove the 0 appended at the end of the file. How can I achieve this?
Any inputs are appreciated.
OriginalPostID-170642
OriginalPostID-170642
Discussion posts and replies are publicly visible
0
sikhivahans
over 8 years ago
@phanibabuk Hope you are just looking forward to clean the '0' appended at the end of file name. You could accomplish the task by exploring the Text functions at https://forum.appian.com/suite/help/7.10/Text_Functions.html#leftb.28.29. Here is an example for you:
fn!leftb("ReadDoc.doc0",fn!lenb("ReadDoc.doc0")-1). Edit the document's 'name' attribute with the cleansed result.
Further you can think of extending the functionality from hereafter, such as deriving the extension from the file name and checking the existence of invalid characters(such as '0' in your case) other than the extensions(pdf,doc,docx etc) and thereby cleaning the same if there are invalid characters.
Prior to implementation of above, I would like to suggest to check if you are making any mistake in RDBMS Blob Utility plug-in implementation which is finally adding '0' to the resultant file name.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
moritzw
over 8 years ago
I can confirm that I am seeing the same behavior with this plugin. For me the 0 gets appended to just the file name though. I am using the "Edit Document Properties" Smart Service and the approach described above to fix it.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel