Forum Discussion
Table Replace Values (Counting from the right side)
Hello all, good morning.
Would anyone know how to use Table.replacevalues but start counting from left to right?
I have some data as below and would like to change the letter from the third position, left to right.
| Data | Desired Result |
| LE-20 | LE*20 |
| HIMAN&20 | HIMAN*20 |
| DISTAT%10 | DISTAT*20 |
| LUGGAGE@TO | LUGGAGE*20 |
Thank you and best regards,
Hi Anonymous ,
You can use Table.TransformColumns
Code:
Table.TransformColumns(PreviousStep, {{"Solution", each Text.Start(_,Text.Length(_)-3)&"*20", type text}})
Regards
KT
2 Replies
Hi Anonymous ,
You can use Table.TransformColumns
Code:
Table.TransformColumns(PreviousStep, {{"Solution", each Text.Start(_,Text.Length(_)-3)&"*20", type text}})
Regards
KT
NewStep=Table.TransformColumns(PreviousStepName,{"Data",each Text.ReplaceRange(_,Text.Length(_)-3,3,"*20")})
