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

Question

Question

String Functions

asked on May 15

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

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 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

That does not look like a token from Token Calculator.

0 0
replied on May 16

Hi jeff,

Use function MID of token calulator activity.

regards,

Marco.

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

Sign in to reply to this post.