BODS unable to parse comma in folder structure

[Former Member]

Hi,

When the folder structure has commas, bods 4.1 is not accessing the complete directory..

However file_exists functions return 1 as expected.

To elaborate, check highlighted folder name which is comma separated

M:\Source\03 Source\3.5 Developments, User Interface, Integration

Error:

12780 13500 FIL-080101 5/09/2014 6:08:34 PM Cannot open file </M:\Source\03 Source\3.5 Developments>. Check its path and permissions.

But when the folder structure is M:\Source\03 Source\3.5 Developments (without commas in folder name) then the files are accessible.

Please help to resolve?

Tried to enclose the path within double quotes as well. No luck..

[former_member205887]

Hi Nisha,

Save the below path in a variable and try accessing it.

'M:/Source/03 Source/3.5 Developments, User Interface, Integration'

[Former Member]

It doesn't work that way as well.

Same result even if passed via variables.

[former_member205887]

Did you try using forward slash in the path ?

[Former Member]

Yes. Reversed the slashes. Tried double quotes to enclose. Tried to concat commas manually.

None worked.

File exist checks work. Only when we expect the files to be read or written into this folder, it fails.

It only considers the path until the first comma. Hence fails as the path is incorrect as no such path exits.

Full path: M:\Source\03 Source\3.5 Developments, User Interface, Integration

BODS considered path:  M:\Source\03 Source\3.5 Developments

[former_member200473]

please try with below mentioned steps :

1-you can use one script before extration dataflow/workflow for changing all the "," to "\" and then pass this path to variable.

2 use this variable to extraction file and then execute this job.

Hope this works.

Shiva Sahu