Re: how to get the file name of an attachment field

2007-04-04 Thread Heider, Stephen
E ' + @TableName + ' SET ' + @FieldName + ' = ' + '''' + @NewName + '''' + ' WHERE C1 = ' + '''' + @RequestID + '''' EXEC sp_executesql @Command HTH Stephen -----Original Message----- Fro

Re: how to get the file name of an attachment field

2007-04-04 Thread Vinson
Michiel, I create 3 filters as you suggested and use goto action. Now it works like a charm... Thanks for great help. On Apr 4, 4:26 pm, Michiel Beijen <[EMAIL PROTECTED]> wrote: > Create a set fields action to a characterfield > Use workflow which searches for the first \ character and use the

Re: how to get the file name of an attachment field

2007-04-04 Thread Michiel Beijen
Create a set fields action to a character field Use workflow which searches for the first \ character and use the right part of the string. Then re-start this workflow, either by using a filter guide or a goto action, until there is not a \ character left in the string. This is not as easy as you

how to get the file name of an attachment field

2007-04-04 Thread Vinson
Hi, I want to design a filter to notify my user when a file is upload to an attachment field. I've try to use $attachmentfieldname$ in the email to get the file name but it is included with path that I want to remove. How can I get the file name without the path of the attachment field? Thanks.