[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

TrinadhB (Boda Trinadh) September 7, 2022, 6:23am 6

Hi @Snow , welcome to the community!

In your for each row, you can assign item(1) = item(1).tostring.split(";"C)(0).tostring.trim
Then, you can see
Andy 7
Belle 6
Clark 9

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