Replace last two digits and replace with number from another column

[joanq]

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?

[Ladarthure]

Hi @joanq,

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!

[sparksun · Accepted solution]

Here is my try FYR.

[messi007]

@joanq,

Please see below:

Attached the workflow,

Hope that helps!

Regards

[joanq]

thank you very much! it worked.

[Exacto99]

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

[messi007]

@Exacto99,

You can do that using a formula tool :

Attached the workflow,

Regards