topic Re: Adding a simble between a number of letters with Calculation in Product Forum

Adding a simble between a number of letters with Calculation

LorenzoCapoccia — Sun, 02 May 2021 17:25:03 GMT

Hi Folks,

I would like your help to do the following please... and thank you in advance for your help and time

Basically, I have data item 5655abc, and with the calculation stage I am trying to have the dash level sign (-) added
to provide the following result 5655-abc, but I am having problem... can you please help?

Thank you once again

Re: Adding a simble between a number of letters with Calculation

KaranSareen — Sun, 02 May 2021 23:24:49 GMT

Hello Lorenzo

You should be able to get the output by using the steps in the attached image:

I hope you'll find this helpful. Let me know if you have any doubts

Re: Adding a simble between a number of letters with Calculation

Pranitha_Durgam — Wed, 19 Mar 2025 07:16:15 GMT

Hello,

The below solution may help you by storing the data in a data item called "Data", and if the data is changing but with same number of digits and alphabets.

use calculation stage and perform this:
Left([Data], 4) & "-" & Right([Data], 3)

Re: Adding a simble between a number of letters with Calculation

Pranitha_Durgam — Wed, 19 Mar 2025 11:35:43 GMT

Hello,

I have come up with another approach where it can be used when number of digits and alphabets are not known.

So, in this approach I am using ToNumeric() function to convert each character of the word into numeric, it works if that character is digit but fails when it is an alphabet.

When it is a digit, I am appending that character to the data item "digits"

When it is character, it moves to the recovery mode where I append that character to the data item "alphabets" and resume it to continue to process next character.

after all characters are processed, on performing:

[digits] & "-" & [alphabets] in a calculation stage, it will give the desired output