-
1. Re: Split/Cut text after last 2 delimiters
Deepak RaiOct 17, 2018 7:03 PM (in response to Tim Guth)
Split( your column, “,”,1)
-
2. Re: Split/Cut text after last 2 delimiters
Tim Guth Oct 17, 2018 7:26 PM (in response to Deepak Rai)Hey Deepak,
that won't work since I stated that the information I want to extract is sometimes also delimited by a comma. So I have to choose a way to split everything before the LAST 2 comma.
-
3. Re: Split/Cut text after last 2 delimiters
Deepak RaiOct 17, 2018 8:45 PM (in response to Tim Guth)
-
SPLIT_FINDNTH.twbx 16.3 KB
-
-
4. Re: Split/Cut text after last 2 delimiters
Tim Guth Oct 17, 2018 9:06 PM (in response to Deepak Rai)Perfect,
thanks a lot!
-
5. Re: Split/Cut text after last 2 delimiters
Deepak RaiOct 17, 2018 8:54 PM (in response to Tim Guth)
Welcome!!! Please Close The Thread also by Marking my Reply as CORRECT. This would Help Others. The CORRECT button is under my Reply in your Main Thread, not in email.
Thanks
Deepak
-
6. Re: Split/Cut text after last 2 delimiters
Tim Guth Oct 17, 2018 9:06 PM (in response to Deepak Rai)Marked as correct
What if I have a case like
James Smith 43 year old 18%, "1,80", 86
in between all my observation, but I don't want to pay respect to the comma in the ". Do I need a regular expression for this?
-
7. Re: Split/Cut text after last 2 delimiters
Deepak RaiOct 17, 2018 9:09 PM (in response to Tim Guth)
So what should be output in this case?
-
8. Re: Split/Cut text after last 2 delimiters
Tim Guth Oct 17, 2018 10:57 PM (in response to Deepak Rai)Long String Field
James Smith 43 year old 18%, "1,80", 86
Thomas Miller 1980 16.5%, 187, 81
Dean Thomas, 36 year old 13.1%, 174, 71
Desired Outcome:
James Smith 43 year old 18%
Thomas Miller 1980 16.5%
Dean Thomas, 36 year old 13.1%
In your code you defined to cut off (-2) after the second last comma. However, the comma is now part of the text indicated with "text". If I use your formula, it cuts of like this: James Smith 43 year old 18%, "1 but desired is James Smith 43 year old 18%