Hi all, I have some values that are looped through for each and now I want to split the value in order to perform a type into activity but I’m getting an error. The value is like: V2527466300200:D8518 and I need to get the split value as V25274663002 so that I can type into it to some desired fiel…

I hope Substring method would work upon the second requirement [image] Palaniyappan: str_input = IF(row(“yourcolumnname”).ToString.Contains(“:”),Split(row(“yourcolumnname”).ToString,”:”)(0).ToString.Substring(0,Split(row(“yourcolumnname”).ToString,”:”)(0).ToString.Length-2),row(“yourcolumnname”…

How to split a value after some places in excel row

Help

Palaniyappan (Palaniyappan P ) November 28, 2019, 7:38am 13

Kindly try this and let know for any queries or clarification
Cheers @vishnu_prasad21

Topic		Replies	Views
Output text after space in cells Activities excel , activities , question	12	894	June 14, 2022
I want to split a string with delimiter '-' and get the result of the first three characters before the delimiter in the same sheet Studio datatable , selector , activities , question	4	2984	March 20, 2020
How to divide String Help excel , activities , string , question , data_manipulation	10	1610	November 28, 2019
Split "," and put into each column Help excel , activities , string , question , data_manipulation	6	1855	December 26, 2019
How to split value after certain place Activities excel , activities	6	1051	August 9, 2021

How to split a value after some places in excel row

Related topics