Splitting text into multiple fields and proper field values

[Marina_Kelner]

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,

[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: