docs.fs_cleanStringForFilename - FN

type: FN ( scalar function ), modify_date: 2021-12-03 18:31:55

RepoObject_guid: 7ED7F831-FD22-EC11-8525-A81E8446D5B0

Description

Examples

Parameters

(nvarchar(4000))
@source_string (nvarchar(4000))

Entity Diagram

References

Referencing Objects

docs.AntoraNavListPage_by_schema - V
docs.AntoraNavListPage_by_type - V
docs.AntoraNavListRepoObject_by_schema - V
docs.AntoraNavListRepoObject_by_schema_type - V
docs.AntoraNavListRepoObject_by_type - V
docs.AntoraPage_ObjectBySchema - V
docs.AntoraPage_ObjectByType - V
docs.ftv_RepoObject_AntoraXref - IF
docs.IndexSemanticgroupPatterndatatype - V
docs.ObjectRefCyclic_EntityList - V
docs.RepoObject_OutputFilter - V
docs.RepoObject_OutputFilter_T_gross - V
docs.ssis_navlist_package - V
docs.ssis_PackageConnectionList - V
docs.ssis_PumlPartialDftComponent - V
docs.ssis_PumlPartialTaskComponent - V
docs.ssis_Task - V
docs.ssis_TaskList - V
docs.usp_AntoraExport_ObjectNavigation - P
docs.usp_AntoraExport_ObjectPage - P
docs.usp_AntoraExport_ObjectPartialsContent - P
docs.usp_AntoraExport_SsisPage - P
docs.usp_AntoraExport_SsisPartialsContent - P
reference.RepoObject_ReferencedReferencing - V
reference.RepoObjectColumn_ReferencedReferencing - V
repo.ForeignKey_gross - V
repo.RepoObject_gross - V
repo.RepoObject_gross_persistence - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

sql_modules_definition

docs.fs_cleanStringForFilename - FN script

CREATE Function [docs].[fs_cleanStringForFilename]
(
    @source_string NVarchar(4000)
)
Returns NVarchar(4000)
As
Begin
    Return
	  Lower (
	    Replace ( Replace ( Replace ( Replace ( Replace (
		Trim ( @source_string )
		, ' ', 'blank' )
		, '/', 'slash' )
		, '\', 'backslash' )
		, '*', 'star' )
		, ':', 'colon' )
	)
End;