GET DATA OUT OF A TEXT COLUMBA

[Syndicate_Admin]

Good afternoon, I have a consultation.

I have a column with data from different destinations, what do you formulate or what method is there to separate detinos?

How can I separate in a separate column what is in blue and in another commune what is in red? the idea is that national and what contains CO are in the same column.

I couldn't 😞 thank you

[Syndicate_Admin]

Super, it worked thank you very much. 😄. What pity could you explain to me what makes this measure? @Syndicate_Admin

[amitchandak · Accepted solution]

@Syndicate_Admin , Try new columns like

New column 1 = if(Search("co", [Destino],,0)>0, [Destino], blank())

New column 2 = if(Search("co", [Destino],,0)=0, [Destino], blank())