Extract customer name from filename in the folder table

[Atlas]

I have a folder table and I used to create a file name by combining the values of the INVOICE_ID, INVOICE_DATE, and CUSTOMER_NAME columns from the invoice table. The TEXT function is used to format the INVOIC_DATE as "YYYY.MM.DD". However, instead of generating the correct string, the resulting file name contains a "-" instead of a "#".

CONCATENATE([INVOICE_ID],  
                         "_",
                              TEXT([INVOICE_DATE] , "YYYY.MM.DD"),
		                "#",
			            [CUSTOMER_ID].[CUSTOMER_NAME])

FT-221212-96599F68_2022.12.12#ATLAS.pdf
FT-221212-96599F68_2022.12.12-ATLAS.pdf

Any help is appreciated in extracting the Customer name from the generated filename.