Identify the complete sentence

[Venamma]

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. 

Option	Q
a	Question: How concerned are you about
b	Question: How concerned are you about your m
c	Question: How concerned are you about your mental health:
2a	Question: How do you identify yourself?
2b	Question: How do you Identify you

Expectation:

Option	Q
a	Question: How concerned are you about your mental health:
b	Question: How concerned are you about your mental health:
c	Question: How concerned are you about your mental health:
2a	Question: How do you identify yourself?
2b	Question: How do you identify yourself?

Can someone please help me with the solution?

Regards,

Venamma

[binuacs]

@Venamma One way of doing this with the Tile tool, you need to group the records and find which Q-field has the ?

[Venamma]

@binuacs 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.

[binuacs]

@Venamma I took the max field and updated the workflow

[OllieClarke]

@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 @binuacs 

Hope that helps,

Ollie