How about separate the file name first.. This can be easily done by taking substrings till you meet with the '\' character until you find the last '\' character.
Once you have the file name separated, you can use the whole path string to replace the file name with nothing to get just the path so that way you can have the path and the file name in 2 separate strings...
I had in fact just helped one of my colleagues to do exactly this same thing and all it took were 3 Active links...
Let me know if you need help around writing these active links..
Cheers
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.
----- Original Message ----
From: Mathieu Pitre <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, July 28, 2006 9:33:06 AM
Subject: Set path from local PC. Almost there...
From: Mathieu Pitre <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, July 28, 2006 9:33:06 AM
Subject: Set path from local PC. Almost there...
Hi all,
ARS 6.3
I am trying to separate the file name out of the path by using an active
link to add an attachment in a Display-only attachement field. The first
action works properly because I can use another action to set the field in
a character field and then I see the path and the file name. However, I
would like to have the path in one charater field and the file name in
another character field. To achieve this(I started with the file name)
someone recommended me to use a Set Field SQL as shown below. However, it
does not work when I use the variable($ProdlistFileLocation$) which is my
attachement field. I receive a memory error and my client crashes. If I
manually add the string in the SQL function is works: SELECT SUBSTR
('\\path\path\path\path\FileName.ext',(INSTR
('\\path\path\path\path\FileName.ext','\',-1))+1) FROM DUAL
There is something I dont get. Also if I set a character field containing
the string mentioned above (\\path\path\path\path\FileName.ext) it works.
Is this a bug?
***************************
$ProdlistFileLocation$ = $536880933$
Active Link:
Action#1
Run Process
PERFORM-ACTION-ADD-ATTACHMENT 536880933
Action#2
Set Field
SELECT SUBSTR ('$ProdlistFileLocation$',(INSTR ('$ProdlistFileLocation$','\',-1))+1) FROM DUAL
ARS 6.3
I am trying to separate the file name out of the path by using an active
link to add an attachment in a Display-only attachement field. The first
action works properly because I can use another action to set the field in
a character field and then I see the path and the file name. However, I
would like to have the path in one charater field and the file name in
another character field. To achieve this(I started with the file name)
someone recommended me to use a Set Field SQL as shown below. However, it
does not work when I use the variable($ProdlistFileLocation$) which is my
attachement field. I receive a memory error and my client crashes. If I
manually add the string in the SQL function is works: SELECT SUBSTR
('\\path\path\path\path\FileName.ext',(INSTR
('\\path\path\path\path\FileName.ext','\',-1))+1) FROM DUAL
There is something I dont get. Also if I set a character field containing
the string mentioned above (\\path\path\path\path\FileName.ext) it works.
Is this a bug?
***************************
$ProdlistFileLocation$ = $536880933$
Active Link:
Action#1
Run Process
PERFORM-ACTION-ADD-ATTACHMENT 536880933
Action#2
Set Field
SELECT SUBSTR ('$ProdlistFileLocation$',(INSTR ('$ProdlistFileLocation$','\',-1))+1) FROM DUAL
