Table Replace Values (Counting from the right side)

[Anonymous]

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,

[wdx223_Daniel]

NewStep=Table.TransformColumns(PreviousStepName,{"Data",each Text.ReplaceRange(_,Text.Length(_)-3,3,"*20")})

[KT_Bsmart2gethe · Accepted solution]

Hi @Anonymous ,

You can use Table.TransformColumns

Code: 

Table.TransformColumns(PreviousStep, {{"Solution", each Text.Start(_,Text.Length(_)-3)&"*20", type text}})

Regards

KT