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

Question

Question

How to search for entries with a trailing space?

asked on May 25, 2018

Hello,

 

We have a customer who has some folders with trailing spaces in their names. Whenever a document is supposed to be routed to one of these folders, the Move Entry activity fails with an "invalid object name" error. We've tried to just rename every folder in this directory with the trimmed entry name, but it still fails when it tries to act on one of these folders with a trailing space. So, I'm curious if there's a way to search specifically for these folders with trailing spaces so we can manually remove the trailing space. Anyone know what the search syntax might look like off the top of their head?

 

Thanks!

0 0

Replies

replied on May 25, 2018

Hi Jacob, you can use a token with Regular Expression, then a search function to identify all affected folders, then modify your workflow to add a rename function for each entry from Search.

0 0
replied on May 25, 2018

Hi Lidija,

Can you elaborate a little bit? I'm not sure I'm following how to incorporate the token into a search that will find all folders with a trailing space.

 

Thanks!

0 0
replied on May 25, 2018

Actually, try this:

1. Search Repo query is like this (the F specifies that we are dealing with a folder): {LF:Name="*", Type="F"} & {LF:LOOKIN="LaserFiche\test"}

Make sure you change that bolded section to correspond to your test folder (I wouldn't do all folders just in case, you can manually create some folders with trailing spaces)

2. For Each Entry, output of Search Repo

3. Conditional Sequence: 

So make sure you select the token from For Each Entry, and Current Entry name, then apply the regular expression to it (like in the first screenshot I provided)

4. Rename entry: the goal is to keep the same name and just trim the spaces, so we will use the trim function.

5. Track Tokens is optional.

Let me know if that helps, my little test I setup worked. 

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

Sign in to reply to this post.