Caio Euzébio Posted August 20, 2019 Posted August 20, 2019 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 Posted August 20, 2019 Posted August 20, 2019 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 Posted August 20, 2019 Author Posted August 20, 2019 Nice, Thank you so much comment. I will try and return results. Regards!
Recommended Posts
This topic is 2168 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now