fmp17 "Text To Columns"

[Caio Euzébio]

Hi Guys,

There are any logic or resource that i can use to make like a "text to columns".

Make text from field one flow to another fields but only with in the middle of coma regarding your sequence, like a excel?

Full text with Comas	Text1 Separated	Text2 Separated	Text3 Separated
How,Are,You?	How	Are	You?

Could please help me, i need a lot of this resource.

 

 

[comment]

Splitting text by a delimiter (a.k.a. "tokenizing") is easy. However, the requirement to have a field for each token is problematic: the text can contain any number of commas - but the number of fields must be fixed in advance. Perhaps it would make more sense to split the text into separate records in a related table?

Anyway, given a text of "How,Are,You?", the following expression:

GetValue ( Substitute ( text ; "," ; ¶ ) ; 2 )

will return "Are". 

[Caio Euzébio]

Nice,

Thank you so much comment.

I will try and return results.

Regards!