Question

String Functions

Workflow

Updated May 16, 2019

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.

Thanks

Jeff

0 0

Replies

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:

%(TrimTimeAfterT#@Left(4)@#)

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.

https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/#../Subsystems/LFWorkflow/Content/Resources/Tokens and Regex/Token Functions.htm%3FTocPath%3DWorkflow%7CWorkflow%2520Designer%7CBuilding%2520Workflows%2520and%2520Business%2520Processes%7CTokens%7C_____2

Jeff

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.

regards,

Marco.

0 0

You are not allowed to follow up in this post.

Question

Question

String Functions

Replies

Sign in to reply to this post.