remove Text "C"

[RAHULBANDI]

Hi 

I have data-set with around 50k Records,

ex-data

C555354
C555355
555356
C555357
C555358
555359
C555360
C555361
555363
C555362
C555364
C555365
C555366
555367
555368
555381
555382

I have used custom column >> TextAfterdelimiter

it is showing as error >> cannot convert number to text

I want to remove "C" from the column

[Jos_Woolley · Accepted solution]

Hi,

Add a Custom Column with this formula:

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

Regards

[Vijay_A_Verma · Accepted solution]

There are many ways to accomplish this. One way is

= Text.Replace(Text.From([Data]),"C","")

This will look like this in Advanced Editor where you can make it type number

= Table.AddColumn(Source, "Custom", each Text.Replace(Text.From([Data]),"C",""), type number)

You can also use Table.ReplaceValue

Table.ReplaceValue(Source,each [Data],each Text.Replace(Text.From([Data]),"C",""),Replacer.ReplaceValue,{"Data"})

[Jos_Woolley · Accepted solution]

Hi,

Add a Custom Column with this formula:

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

Regards