Example I have variable lot_no as string = 068_160266 But I want to read data in column Month that what month? and convert to month number [image] Example I have variable lot_no as string = 068_160266 that month = Feb , I want to convert FEB to 2 Expected output : I want output = 2 Ple…

[image] Palaniyappan: str_monthnumber = Datetime.ParseExact(Strinput.ToString, “MMM”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”) Then mention like this str_monthnumber = Convert.ToInt32(Datetime.ParseExact(Strinput.ToString, “MMM”, System.Globalization.CultureInfo.Inva…

Read data from another column

Help Activities

Palaniyappan (Forum Leader) January 31, 2022, 12:43pm 6

Then mention like this

str_monthnumber = Convert.ToInt32(Datetime.ParseExact(Strinput.ToString, “MMM”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”)).ToString

Cheers @fairymemay

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Excel get value from Excel based on other value Activities excel	5	1174	December 12, 2021
Converting month to corresponding number Help	4	2957	September 13, 2019
Int converted in string (month) Help	5	2076	May 13, 2019
How to change month to number Studio uiautomation , activities , studio , date , datetime	45	705	September 4, 2023
How to convert Month(Text) into number? Help	6	11100	September 18, 2019

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

Read data from another column

Related Topics