How to get the Extension of an attachment in sys_attachment table

[Ashok32]

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.

[Brian Lancaster]

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.