Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
3 years ago
Solved

remove Text "C"

Hi  I have data-set with around 50k Records, ex-data C555354 C555355 555356 C555357 C555358 555359 C555360 C555361 555363 C555362 C555364 C555365 C555366 ...
Need Help
Show and Tell
Jos_Woolley's avatar
Jos_Woolley
Solution Sage
3 years ago

Hi,

Add a Custom Column with this formula:

if Text.Start(Text.From([Column1]), 1) = "C" then
     Replacer.ReplaceText([Column1], "C", "")
else
     [Column1]

Regards