[20220907_121742] For each excel row, I wish to retain only the first character of Column B and delete the rest of the text in the excel cell. For example Andy: to keep only ‘7’ in column B.

Hey! Try this: Read range - Output as - DtOut Take one for each row in data table pass the DtOut Take one assign activity and create one integer variable as Counter initialize with 1 Assign Counter = 1 Take one assign activity and pass the expression like this Assign First = System.Text.Regul…

How to keep only the first character in an excel table?

Help Studio

muthuraj.c (Muthuraj) September 7, 2022, 7:49am 7

Try This

Xaml is attached
DT_Update.xaml (5.7 KB)

Thanks,
Muthuraj

2 Likes

Topic		Replies	Views
Excel extract specific set of words from a Column Studio datatable , studio , regex , question	10	2718	September 10, 2020
Excel application Help	18	1940	April 9, 2018
Separate text in Excel StudioX studiox , question	6	400	October 9, 2023
Extract numbers only from Excel column Activities datatable , excel , activities , question	8	2768	March 24, 2021
Extract only selected data Help	25	1797	June 11, 2019

How to keep only the first character in an excel table?

Related topics