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?
Solved! Go to Solution.
Hi @joanq,
multiple methods here, but first transform your data in string fields
Hope it helps!
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 |