Friday, September 11, 2020

Power Query - Text.Pad / LPAD

    StepPAD = Table.ReplaceValue(DIM_SAP_Grupo_Preco_Clientes1, each[PRICE_GRP], each Text.PadStart(Text.From([PRICE_GRP]),2,"0"),Replacer.ReplaceValue,{"PRICE_GRP"})

No comments:

Post a Comment

Power Query - funcao limpa replace texto numero

//fnc_limpa_texto (TextValue as nullable text) => let     SafeText = if TextValue = null then "" else TextValue,     DigitsOnly...