You are viewing limited content. For full access, please sign in.



String Functions

asked on May 15, 2019

I have a string - representing a date eg.   20190515

I would like to format it to 2019/05/15.   I do not need it to be a date specifically, as this is used for filing by date structure, so I want to simply convert it.


input string/token:  20190515

output token after formatting 2019\05\15


This is trivial with Ltrim type string functions however these do not seem to be available in workflow.


Any help would be much appreciated.







0 0


replied on May 15, 2019

I think you mean Left, not LTrim as LTrim is usually for removing leading spaces. Token Calculator offers both Left and Right functions.

0 0
replied on May 15, 2019 Show version history

I am trying:




Where 'TrimTimeAfterT' is a string 20190515


This does not give me 2019,   I am looking through the docs for Function info, so far not finding any docs on Left functions.


Here is the doc page that seems to list the Token functions, Left / Right are not on this list. and Regex/Token Functions.htm%3FTocPath%3DWorkflow%7CWorkflow%2520Designer%7CBuilding%2520Workflows%2520and%2520Business%2520Processes%7CTokens%7C_____2





0 0
replied on May 15, 2019

That does not look like a token from Token Calculator.

0 0
replied on May 16, 2019

Hi jeff,

Use function MID of token calulator activity.



0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.