Solved Manipulate string in blue prism

rpaccount

Member
Hi all,

I need to remove the ext part of a filename
E.g. Filename.pdf, Filename.xlsx, Filename.xxxxxx

Need to remove that pdf, xlsx (ext) part, so that i will only get filename
Would appreciate if anyone could help me in this

Thanks!
 

VJR

Well-Known Member
Hi all,

I need to remove the ext part of a filename
E.g. Filename.pdf, Filename.xlsx, Filename.xxxxxx

Need to remove that pdf, xlsx (ext) part, so that i will only get filename
Would appreciate if anyone could help me in this

Thanks!
Hi rpaaccount,

How is the filename format?
If you have only 1 dot . in the file name just before its extension then you can use this approach.
Else if there are multiple dots as below then that won't work.
eg; ABC1.DEF.pdf

If you have multiple dots then you will need to do an InstrRev ie; find the position of the dot from the reverse end and then get the remaining characters.
 

rpaccount

Member
Hi,

Thanks for ur help.
So does the InstrRev requires the use of code stage? Cause i wanted to do it at process level.
 

rpaccount

Member
Hi,

I'm not too sure what to put for Start Byte and Position for that object.
Could you help to explain it to me?

Thanks!
 

VJR

Well-Known Member
Hi,

I'm not too sure what to put for Start Byte and Position for that object.
Could you help to explain it to me?

Thanks!
Pass the Input text and the Search string which is the pipe symbol | in your case.
Position must be an output parameter which is returned after the action is run indicating the position where the above search string was found.
 
Top