Hi, I have a task to query a telephone number from my database. The result of the database query is varied. Here are some example : +621234561412, 01251265236, 62124162316326, +6251325235213 62123445432, 01256236432 01232115156, +62163434636 8913214214 The goal is : I have to output the fir…

[image] Rhys18: +621234561412, 01251265236, 62124162316326, +6251325235213 @Rhys18 , Could you check with the below Expression : Let str be the string variable which contains the data, then we can perform a split based on comma and convert it to an array of String. We can then perform a mod…

How to split and read first character of string

Help Activities

Rhys18 (Rizky Albert Hartono) September 29, 2022, 12:39pm 5

Ok, I assume you still confuse about the output. Here’s the expected output :

1 Like

Topic		Replies	Views
Split string in one column to row Studio studio	2	799	April 29, 2021
Remove part of data from a particular cell Help datatable , activities , string , question , data_manipulation	5	1100	December 26, 2019
Separating string in an excel column Activities excel , activities , question	6	1310	September 25, 2021
Split string in a cell Help datatable , excel , activities , studio , string	9	1687	September 5, 2018
How to divide String Help excel , activities , string , question , data_manipulation	10	1589	November 28, 2019

How to split and read first character of string

Related topics