• Miscellaneous Functions
  • ASSIGNEDTO Function
  • B64TOGUID Function
  • BROWSTAT Function
  • CANSIGN Function
  • CELLCALC Function
  • CELLCOL Function
  • CELLLABEL Function
  • CELLNO Function
  • CELLROW Function
  • CELLSTR Function
  • CELLTABLE Function
  • COMPLETION Function
  • COMPLTBY Function
  • CUSTPROP Function
  • CUSTPROPAT Function
  • CUSTPROPR Function
  • CVDATA Function
  • CVDATAC Function
  • CVDATAL Function
  • CVDATALNG Function
  • CVDATAQRY Function
  • CVDOCPOS Function
  • CVFORM Function
  • CVGROUP Function
  • CVIDEA Function
  • CVINFO Function
  • CVMENUST Function
  • DOCENTSCP Function
  • DOCID Function
  • DOCLIBPATH Function
  • DOCMODE Function
  • EVAL Function
  • FIELD Function
  • GETHIDE Function
  • GUIDTOB64 Function
  • HASTAG Function
  • INITIALS Function
  • INPBLANK Function
  • INPBLANKRC Function
  • ISADMIN Function
  • ISCONS Function
  • ISINGROUP Function
  • ISLOCKED Function
  • ISPLHOLDER Function
  • ISSUECOUNT Function
  • ITEMPROP Function
  • KLIEXIST Function
  • KLIPROP Function
  • KLLPROP Function
  • LEVEL Function
  • LOOKUP Function
  • Miscellaneous Functions
  • MKPATH Function
  • NUMROLES Function
  • NUMSIGNED Function
  • RDYREVIEW Function
  • REPENT Function
  • ROLECOMPLT Function
  • ROLEINDEX Function
  • ROLELABEL Function
  • SCRNX Function
  • SCRNY Function
  • SIGNOFF Function
  • SIGNOFFCHK Function
  • SIGNOFFCVR Function
  • SIGNOFFDTE Function
  • SIGNOFFNME Function
  • WHOAMI Function

MKPATH Function

The MKPATH function converts a string parameter path name to an expended path string by replacing each \ with a \\.

Syntax

MKPATH(expression)

Example 1

mkpath("a\b\c")

Returns a\\b\\c

Example 2.

mkpath(c5)

Returns a\\b\\c if cell c5 contains "a\b\c"

Example 3.

mkpath("\\a\\b\\c")

Returns \\a\\b\\c

Example 4

mkpath("\\a\b\c")

Returns \\\\a\\b\\c (network path)

Example 5

mkpath("c:\a\b")

Returns c:\\a\b

Related Topics

• Miscellaneous Functions