How to get the Extension of an attachment in sys_attachment table

Ashok32
Tera Contributor

‎11-17-2023 03:22 AM

Hi All,

 

I have a requirement like to get the file extension of an attachment from Sys_attachment table.

 

I need to pass the file name .extension in flow designer.

Can any one suggest the script to pass that in Flow designer.

 

 

Thanks in advance.

0 Helpfuls
  • 557 Views
1 REPLY 1

Brian Lancaster
Tera Sage

‎11-17-2023 09:57 AM

You would have to lookup the record in the sys_attachment table then you could do a split on the file name based on the period. Then take the second half of the split.

0 Helpfuls