Splitting text into multiple fields and proper field values

Currently, I have large text set in 1 field (Comments) with various information in Questions/Answer. I am looking to separate each question via proper column and prefill proper columns with corresponding answers. Can someone please help how i can tackle it? -------------------------------------

• What is your name?

John Doe

• What is your favorite color?

Blue

• Where do you live?

New York

-----------------------------------------

thank you,

Datasets

Regex

Transformation

Text Mining

Accepted answers

nagakavyasri

@Marina_Kelner try if this works:

Screenshot 2024-09-18 161116.png

9-18-24.2.yxmd

All comments

apathetichell

Post some real sample data - if your data really looks like this - perhaps use text to column and split by ?

Marina_Kelner

Hi, Data doesn't look like that unfortunately for all of the cases. For those users who do follow instructions they put it in that format, others don't. I am concentrating right now who does follow and puts text like this. I am looking for REGEX options that can help me maybe to extrapolate text between questions?

apathetichell

That was my expectation - you can try regex in parse mode - and set your questions as defining breaks between responses -but this would be much easier with some sample data.

nagakavyasri

@Marina_Kelner try if this works:

Screenshot 2024-09-18 161116.png

9-18-24.2.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335