Payment File Structure- double quoting embedded commas

[former_member200567]

Hi  experts,

Here is my bank payment file delimited with commas.

The format includes just 4 fields.

format->           Header,CompanyName,CompanyID,IsLocal

sample data -> HD,Sample Company CO., LTD,1,NO

But the bank requires to double-quote fields with embedded commas.

I need to double-quote the company name "Sample Company Co., LTD" because it contains a comma.

I don't know how to do that.

Please kindly suggest.

Thanks in advance.

Best Regards,

Fred.

[Former Member · Accepted solution]

Hi Fred,

  The easiest way to do is to create two fields before and after Company name, which holds the constant value in this case double quotes ( " ). This works as a concatenate.

Hope this helps.

Thanks,

Santosh Kumar J

[former_member200567 · Accepted solution]

Hi Santosh,

        Nice idea.

        But the result will be like this ",Value,".

        Is there any other option?

Best Regards,

Fred

[Former Member · Accepted solution]

Hi Fred,

   Options are very limited on UI File structure creation compared to back end DMEE tree structure, as it has no concatenate option. So I have no other solution to propose. I feel you may have to give try with PDI solution for this requirement.

Thanks,

Santosh Kumar J

[former_member200567 · Accepted solution]

Thanks Santosh,

Best Regards,

Fred

[Former Member]

Not sure if I understood your scenario properly, but can't you check if the company name is having "," in it and if yes the just concatenate double quotes?

You can use Find function to search for comma.

Thanks & Regards,

Meghna

[former_member200567]

Him Meghna Sharma.

     Thanks for your answer.

     And sorry for my incomplete question.

     I am creating the bank payment file structure in Business Configuraion-> Fine-Tune-> Outgoing Bank Transfer-> Edit Payment File Structure.

     

Best Regards,

Fred.

[Former Member]

Hello Fred,

My solution was for the scenario to create Payment File through PDI. I am not sure about creating payment file from Fine Tune. I need to check.

Thanks & Regards,

Meghna