Hi All, Good Day! In Excel i have the column name called as “Unit”. In that column i have multiple row values like as “A0123456789” & “0123456789"combined with alpha Numeric and numeric value. If the value is Numeric i want add the letter like as “0123456789:AA”, if it,s alpha Numeric need add lett…

Hello @BaskaranVenkatesan you can do both the problems using linq use an Assign Activity and assign this code in an Assign Activity (from r In DT.AsEnumerable() Let x= if((System.Text.RegularExpressions.Regex.IsMatch((cstr(r("Unit"))),"[a-zA-Z]\d+")),(cstr(r("Unit"))+":BB"),(cstr(r("Unit")))+":A…

Hi Vicky, Thanks for your response. I’ll check and get back if have any concern.

AlphaNumeric in Excel Column

Help

pattyricarte (Patty Boy) September 12, 2019, 11:11pm 2

Hi @BaskaranVenkatesan

Have you already tried it. you just need to format the datetime and use concatenation in the unit thats all.

cheers

Happy learning

Topic		Replies	Views
How to convert column values from ddmmyyyy to ddmmmyyyy without loop for single column Activities excel , uiautomation , activities , linq , linq-query , expression	3	1285	March 31, 2022
Concatenate 2 Column into 1 Column Studio datatable , studio , question	19	4697	April 7, 2021
Separar numeros de letras Ask in Your Language studio , question	5	1068	January 13, 2023
To write into excel Help	1	976	July 16, 2019
Date format change in excel column Activities excel	29	6155	October 22, 2020

AlphaNumeric in Excel Column

Related topics