String Split with file extension

SyntaxEditor Code Snippet


i am storing file name in the table. need to retrieve the filename extension on the table record to display the extension alone in one of the table Column. how do i do it.

String_Split(MDDocumentTable.List.Current.MD_Documents.FileName,".")

RMS wrote:

SyntaxEditor Code Snippet


i am storing file name in the table. need to retrieve the filename extension on the table record to display the extension alone in one of the table Column. how do i do it.

String_Split(MDDocumentTable.List.Current.MD_Documents.FileName,".")

Hi RMS,

you can get the extension of the image from the output of the string split by using the below code

SyntaxEditor Code Snippet

String_Split.List[1].Text.Value




use this:

just drag and put yours accordingly:

Solution

IF( String_Split(MDDocumentTable.List.Current.MD_Documents.FileName,".").length>1,

String_Split(MDDocumentTable.List.Current.MD_Documents.FileName,".")[1].Text.Value,"")


Solution

Thanks for the prompt response, Worked Well.