Add 0 to Column in Excel

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi,

I have this column in excel and I want to add a “0” in front of all values in the column <ASOS_PO>.

So <500005215980> becomes <0500005215980>.

Can someone help please?

Thanks!

[kumar.varun2 (Varun Kumar)]

@Yudhisteer_Chintaram1

"0" + colValue.ToString

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi @kumar.varun2 ,

It woked but I have one more constraint. Can I add “0” only to values where it does NOT start with <50000>.

That is ignore all values starting with “50000”. Thanks!

[pravin_calvin (pravin kumar)]

Hi @Yudhisteer_Chintaram1

You can use if condition in this case yourcolumnvalue.toString.contains(“5000”)

else part you can have the string concatenation with the column values.

Regards

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

I tried that. It works but contains check if 50000 exists anywhere in the value as I want to check if it STARTS with 50000.

[prasath17 (Guru)]

@Yudhisteer_Chintaram1 - Please check this…

“50000521978”.Substring(0,6).Contains(“50000”)
true

or we can use Regex.ismatch to check the value at the start…

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

@prasath17

Like that:

It is not working

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

The whole process

[prasath17 (Guru)]

@Yudhisteer_Chintaram1 - is it possible to share the sample sheet with just one column??

[ermanoj3101 (MANOJ)]

Hi @Yudhisteer_Chintaram1 ,

Try like this.

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

No no it works. Just a minor typo

Thanks!

[Gokul001 (Gokul Balaji)]

Hi @Yudhisteer_Chintaram1
Sample workflow and excel that is use full for you.
Book1.xlsx (8.9 KB)

Main.xaml (9.1 KB)

Please mark it as solved.