The text splitter function is a valuable tool for extracting things like first and last names from incoming strings. Currently, it allows users to split a string by selecting a space as the delimiter and choosing either the first, second, third, etc value. However, there are cases where constituent input where some strings have first, middle, and last names within the same string.

To enhance the functionality of the text splitter, it would be beneficial to have the option to select the first value in the delimited string as the first name and the last value as the last name. For instance, if we have a string like "Robert C Hernandez" and use a space as the delimiter, we could select "First value" for the first name and "Last value" to extract "Hernandez". This approach would enable us to extract the desired values regardless of the length of the string or the number of spaces it contains.

By implementing this improvement, we can streamline the process of extracting first and last names from complex strings, making it more efficient and user-friendly.

It would be very helpful to have the ability to choose which field we would need to parse in the connector. Right now, the Stripe connector uses the Customer Name field for parsing but name information lives in multiple name fields within the connector. If we could use Charge Billing Details - Name for parsing, that would be ideal.