Identify the complete sentence

Question

Hi Team,

I have a data set which is not in proper format and I have to identify the complete sentence from the given column and populate the same for other options as well so it looks meaningful.

OptionQaQuestion: How concerned are you about bQuestion: How concerned are you about your mcQuestion: How concerned are you about your mental health:2aQuestion: How do you identify yourself?2bQuestion: How do you Identify you

Expectation:

OptionQaQuestion: How concerned are you about your mental health:bQuestion: How concerned are you about your mental health:cQuestion: How concerned are you about your mental health:2aQuestion: How do you identify yourself?2bQuestion: How do you identify yourself?

Can someone please help me with the solution?

Regards,

Venamma

OllieClarke · Answer

@Venamma

Here's another way of getting to the same point which should be a little quicker:

I remove all non-numbers from the Option and then use that to group the questions before finding the max like @binu_acs

Hope that helps,

Ollie

questions.yxmd

binu_acs · Answer

@Venamma I took the max field and updated the workflow

Group_1004.yxmd

Venamma · Answer

@binu_acs Thanks for the quick response.

This solution works if the sentence has "?", But I have other entries where question doesn't ends with a "?".
How do we deal with such entries?

Lets say in the input If I remove the ? from  sentences, So I'm looking to identify the longest sentence from all the options for a single question.