12-10-2013 07:12 AM
Hi All:
I'm trying to DIP files into OnBase from another LOB application. The file names of those documents were stored on the file share with "spaces" in the documents names. If I try to bring them in using an Ordered DIP process - the process fails as soon as it hits a space in the document's name. Is there a way to remove/trim spaces from a docments name?
e.g.
\onbaseDG$\DIPProcess\DOC_20131125\0005821_INTAKEREPORTS (M 311).RTF
I want to remove the spaces between the "s (" and between "M 3" above.
12-10-2013 07:30 AM
REM This file will remove all instances of " and append the path and filename
@echo off > OUTPUTFILE.txt & setLocal enableDELAYedeXpansion
for /f "tokens=* delims= " %%a in (INPUTFILE.txt) do (
set S=%%a
set S=!S:"=!
>> OUTPUTFILE.txt echo.!S!
)
12-10-2013 07:31 AM
Sorry - This was supposed to paste below this. We use this Batch file to remove " characters. It might work for spaces. Jay
01-03-2014 07:22 AM
Hi Jim,
Is your DIP index file created using Field Delimiters?
If you are using delimiters, filenames with spaces should not be an issue.
As an example, an index file that looks like this, using the double quote delimiter and comma separator imports correctly:
"Photo","Bob Hope","1-1-1970","\\dev-011316\TestData\DIP\Spaces Spaces\File 1.tif"
"Photo","Bill Cosby","2-28-1990","\\dev-011316\TestData\DIP\Spaces Spaces\File 2 .bmp"
"Photo","Brad Pitt","12-2-2001","\\dev-011316\TestData\DIP\Spaces Spaces\File 3 .bmp"
Thanks for using Community!
Roger
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.