Lower case in variable substitution

[Former Member]

Hi experts,

in my scenario I have a receiver CC that put an xml file in a target server.

The requirement is to dynamically determine target directory based on a field on mapping header.

I have used variabile substitution to retrieve the value of the field, and with %% i have put this value on field target directory.

The problem is: value from mapping is in capital letter, but the name of the target directory in which I have to put the file is in lower case letters, and target server is case sensitive.

Obviously I cannot change value in mapping, but I need to put variable in variable substituion in lower letters.

Is it possible?

Thanks

Fabio

[former_member181962 · Accepted solution]

Hi Fabio,

You can try Dynamic configuration for your requirement.

Search for blogs on how to use Dynamic Configuration

Best Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

I'm already using Dynamic Configuration in this scenario to set target directory for a different receiver (i have 3 receivers), therefore I cannot use Dynamic Configuration with different values for another receiver of the same interface.

Fabio

[former_member181962 · Accepted solution]

In that case, you can probably have a dummy field (May be at the end of the field list in the target data type), which should be mapped with a Lower case value. Then use this field in your Variable Substitution.

Do not mention this field in the content conversion, to avoid it from appearing in the output file.

[Former Member · Accepted solution]

Hi,

I don't want to make changes on mapping, is not possible to put lower case in variable substituion?

Thanks

Fabio

[former_member181962 · Accepted solution]

Hi Fabio,

I am not sure if there is some command that we can use in variable substitution to change the file names to lower case.

How about using OS command after processing option to rename to lower case?

Best Regards,

Ravi

[Shabarish_Nair · Accepted solution]

Hi,
> I don't want to make changes on mapping, is not possible to put lower case in variable substituion?
> Thanks
> Fabio

no

also in case you want to put small case in variable substitution why cant you use dynamic configuration and set the values to lower case?

[Former Member · Accepted solution]

Hi,

I'm already using Dynamic Configuration in this scenario to set target directory for a different receiver (i have 3 receivers), therefore I cannot use Dynamic Configuration with different values for another receiver of the same interface.

Thanks

Fabio

[Former Member · Accepted solution]

I am working on the same scenario with small difference, our target folder is static.

Our source is IDoc and file name is coming in Upper case, customer requirement is the file name should be in lower case. The file name format is storing in custom table. hence we requested SAP ECC team to make the domain lower case compatable.

As I know, standard Dynamic Conf functionality will not support this requirement.

Infact I am waiting for the best solution from SDN...

[Shabarish_Nair]

use a simple toLowercase function in your mapping else it is always best to put the correct case sensitive values in your value mapping table

[Former Member]

Hi,

I cannot change values in mapping.

Fabio