0
I am using Google Drive and would like to use a regular expression to separate characters between points, as below :
the Bai Xa men to
the Bai Xo
I need to put in each column, the content between the points (in the first and last case only before and after the point).
a Bai Xa men to => a Bai Xa men to
to Bai Xo => to Bai Xo
I would need a code for each "answer" column For example the Bai Xa men to (a) first letter before the point (b)letter between the first 2 points (c) letter between the second and third point etc.
It does not say what language you want to use (apart from mentioning Regex), but assuming C# for example, you can simply split the string by dots
"a·bai·xa·men·to".Split('.') \\ retorna um array de strings
.– Omni
Oh, it was bad. I’m using google drive. I wanted to put the regular expression inside the formula already available. Like this example below. -on-demand (male name) =REGEXEXTRACT(A3;" [ ()]*") -on-demand In case I need a command for each column where the words will return between the dots(imagine 8 or 9). Valeu!!
– alexandre gouvea
Need regex? You can go to Menu -> Data -> Split Text Into Columns (ai chooses the tab), or use the function
=SPLIT(coluna, ".")
– Adir Kuhn