:truncated to give zero or only 1 character result instead of 4 or 3

[eva.puskas]

I want to generate a code from User VAT ID first 4 + last 2 characters + user’s company name’s first 3 character. truncated to 4 gives no result, truncated to 3 gives 1 character.

See this example - screenshot from database and Workflow change user referral code

VAT ID: DE314842978
Company Name: PepMelon

result should be: DE3178PEP
it gives: 78P

I tried write it out preview, the result is the same. User Data saved before calculation, in another workflow. VATID is in the database at the user. Also not a privacy question, because in that case “:truncated from end to” would not work either. So it should do the work.

Any idea?
Thanks in advance!

[mikeloc]

Hi there, @eva.puskas… I’m guessing you are running into an order of operations type thing because I just created an example using the new (experimental) parentheses feature, and it works like a charm.

Hope this helps.

Best…
Mike

[eva.puskas]

Works like a charm! thank you so much! Hopefully it will be launched, I don’t know how it worked at other apps before this… Anyway, thank you very much!