Special Characters in filenames CAWA ESP (aka Cybermation ESPmSeries) ?

[Anon Anon]

We're on V 11_3 or 3_1; upgrades to 3_4_2 in progress.

 

The issue we're facing is regards to Special Characters in a Windows filename and passing them into WS-FTP for transfer.

This Filename will work:

'd:\FTP\users\viper\oracle\BOFAUS3NXXX_o=bofaus3n,o=swift_MGRMUS44***_o=mgrmus44,o=swift_camt.***.bai2.cdr_LIVE_!user1'

 

but this doesn't:       NOTE that the error is due to the ';' !!!

INVOKE ISAAT.ESPPROC(DIMSV035) 

APPL DIMSV035 WAIT SAF_PROF_APPL POST_OLDEST 

VGET corpagenta    TABLE(SERVER) 

VGET espuserid     TABLE(SERVER) 

VGET transmissions TABLE(SERVER) 

/*NOTIFY FAILURE EVENT($ESP.PISPI130) 

/*NOTIFY FAILURE MAILBOX(Compliance_GDA_Reporting) 

if user1 ^="" then espftfile="\\ad\apps\Prod\FPP\Vector_correspondence\metadata;folderName=Supporting Documents;caseNumber=!user1" 

integer x y 

x = length(!espftfile) 

y = x - 4 

path = "!espftfile(06:40)" 

file = "!espftfile(42:!x)" 

/* this process is to reverse the slashes in filepaths */ 

/* before SFTP'g from Windows to Linux servers         */ 

/* !path is grabbed from ESPFTFILE or ESPWTFILE        */ 

/* and then updates it, use !path in the REMOTEDIR     */ 

REXXON 

path ='apps/Prod/FPP/Vector_correspondence' 

SFTP_JOB DIMSV035.SFTP 

AGENT pmnatms6418 

  RESOURCE (1,ESPFTP) 

LOCALFILENAME "\\pnams511\d$\VECTOR\FileFolder\scannedCorrespondence\metadata;folderName=Supporting Documents;caseNumber=023016081000030.pdf" 

ESPWSS027E folderName=Supporting Documents;caseNumber=023016081000030.pdf" 

ESPWSS004E INVALID STATEMENT SYNTAX 

ESPWSS027E caseNumber=023016081000030.pdf" 

ESPWSS012E INVALID EXPRESSION 

REMOTEDIR "apps/Prod/FPP/Vector_correspondence" 

REMOTENAME "metadata;folderName=Supporting Documents;caseNumber=023016081000030.pdf" 

ESPWSS027E folderName=Supporting Documents;caseNumber=023016081000030.pdf" 

ESPWSS004E INVALID STATEMENT SYNTAX 

ESPWSS027E caseNumber=023016081000030.pdf" 

ESPWSS012E INVALID EXPRESSION 

SERVERADDR pmnacms6506 

  SERVERPORT 22 

  TRANSFERDIRECTION D 

USER espworkload 

  RUN DAILY 

ENDJOB 

NT_JOB DIMSV035.REMOVE 

AGENT pmnacms6506 

  CMDNAME "D:\ISAAP\Scripts\REMOVE.BAT" 

ARGS "\\ad\apps\Prod\FPP\Vector_correspondence\metadata;folderName=Supporting Documents;caseNumber=023016081000030.pdf" 

  RUN Daily 

AFTER DIMSV035.SFTP 

ENDJOB

 

I've looked in all of the manuals but the only reference that I can find to DELIMITERS is " Use single quotation marks when you want to denote character strings and literal data in expressions, in assignment statements, and in built-in functions. You must include single quotation marks around a string that contains blanks. "

 

I was hoping for a way to override the delimiter for this run as I would in a LINUX SH file ( IFS="'"  ) which says single-quote is the only DELIM and therefore accepts anything else in the filename.

 

Has anyone come up with a way to accomplish this short of RENAMING the file changing " ; " to " _ " or " , " before and after the File-Transfer?

Attachment(s)

APPL DIMSV035.docx   14 KB 1 version

[Rick Romanowski]

According to the 11.4 Command Reference Guide the semi-colon is a delimiter.

 

Syntax

This statement has the following format:

LOCALFILENAME file_name[; file_name...]

 

"You can specify multiple files. Separate each file name with a semi-colon."

[Anon Anon]

That's what I already know; I was hoping that someone knew of a way to OVERRIDE the DELIMITER and say for instance that only a SINGLE or DOUBLE-QUOTE was to be considered a Delimiter and therefore ignore when a SEMI-COLON is coded within a filename.

[Rick Romanowski]

I tried many combinations of single and double quotes, but I get the same message every time.

 

I would recommend opening a support case with CA Priority 4, question about use.