Replace last two digits and replace with number from another column

hi all,

can you please help me with this task:

'Replace last digits of XXX with number in YYY column' example:

XXX YYY New XXX

1250 36 1236

12345 22 12322

Can you please help how can I insert such formula in my workflow?

Regex

Custom Tools

Accepted answers

Here is my try FYR.

replace digit.yxmd

All comments

multiple methods here, but first transform your data in string fields

Formulas:
- use the length function to have the number of digits
- use a left function to get the first numbers with a number of char equal to lenght - 2
- add the YYY field to get what you want:
- left([XXX],Length([XXX])-2)+[YYY]
RegEx
- replace the last group of the regex (which will be 2 digits) by nothing and combine it with YYY
- REGEX_Replace([XXX], '(.+)(\d{2})','$1')+[YYY]

Hope it helps!

Here is my try FYR.

replace digit.yxmd

Please see below:

Attached the workflow,

Hope that helps!

Regards

Replace20210119.yxmd

thank you very much! it worked.

How can I replace the first two digits of a string of numbers with two digits from another column? @Ladarthure @messi007

200000002	26	260000002
200009049	26	260009049
200010815	26	260010815

You can do that using a formula tool :

Attached the workflow,

Regards

Community_20240106.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703