String binding

KubotaNatsuki
Contributor

String binding

hi!

 

I want to concatenate the strings!

When displaying the time, I want to use "hour" + ":" + "minute"!

Example: "9" + ":" + "15" → 9:15

I'm not good at English, so this may be difficult for you to understand.

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
vinayvm
Certified Master Anaplanner

Re: String binding

Hi @KubotaNatsuki ,

 

You can achieve this by using & in your expression instead of +, provided all are in text format.

If you have hour and minute in number format, you need to convert it to text by using text function.

 

Therefore, your overall formula should be text(hour)&" : "&text(minute).

However, it is recommended that you maintain the delimiter in an admin module lineitem, and refer it in your expression. This way you can main consistency, and the performance is not hampered.

 

Regards,

vinayvm

 

 

 

View solution in original post

4 REPLIES 4
vinayvm
Certified Master Anaplanner

Re: String binding

Hi @KubotaNatsuki ,

 

You can achieve this by using & in your expression instead of +, provided all are in text format.

If you have hour and minute in number format, you need to convert it to text by using text function.

 

Therefore, your overall formula should be text(hour)&" : "&text(minute).

However, it is recommended that you maintain the delimiter in an admin module lineitem, and refer it in your expression. This way you can main consistency, and the performance is not hampered.

 

Regards,

vinayvm

 

 

 

View solution in original post

KubotaNatsuki
Contributor

Re: String binding

Thanks for your reply!
I was able to create the module I wanted!
Thank you so much!
Jitendra.Vishnolia
Certified Master Anaplanner

Re: String binding

Hey @KubotaNatsuki ,

 

Pls go through Operators and constants - Anaplan Technical Documentation this will be helpful for you to have better understanding of how to combine, compare, and perform mathematical or logical operations with your data.

 

~ Jitendra

KubotaNatsuki
Contributor

Re: String binding

Thanks for your reply!
Thanks for pointing me to that page!
I'm learning so much!