Skip to main content
Solved

Why is the file format incorrect if the field value contains a 'dot'?

  • 6 June 2024
  • 3 replies
  • 35 views

Hi all, 

I have a question about the export file format. I set it up as usual in the report designer. However, if my field "billing name" contains a company name like "ABC Co. Ltd", the  file attach in email will be incorrect and won't have the PDF format. Instead, it will have an "LTD" format.

 

3 replies

Userlevel 5
Badge +1

Hi @dilys,

Perhaps try the Replace function in the Report Designer, to just remove the periods altogether?

So something like:

=Replace([BillingContact.FullName], ‘.’, ‘’)

Hope that helps!

Userlevel 3
Badge

Thanks @craig2 , can you explain why the system is behaving in that way?

Userlevel 7
Badge +10

Typically the file extension type is indicated by .pdf or .jpg etc.  So the period / dot character is telling the system what the extension is. So the system is reading the “. LTD” in the file name as the extension and then the .pdf file extension is not being added.

The suggestion above from @craig2 to remove all the periods/dots from your file name is a good solution.

Reply