Announcements
I have a multilined text box I would like to break up into individual values. Here's an example:Rank Name Specialty Zip5 bob psychiatry 32123
6 larry oncology 45654
8 howard chiro 78987
10 fred ont 65498
1. How can I extract line two into a text box? '5 bob psychiatry 32123'
2. How can I then extract the third item on line two into a text box? 'psychiatry'
Please and thank you!
@kgiles123 ,
You can combine the Index and Split functions, like the example below. Use the row index and column index values to indicate the row and index you want to retrieve.
Also, if you use different separators, make sure to indicate them.
Index( Split( Index( Split( "Rank Name Specialty Zip" & Char(10) & "5 bob psychiatry 32123" & Char(10) & "6 larry oncology 45654" & Char(10) & "8 howard chiro 78987" & Char(10) & "10 fred ont 65498", Char(10)// This is the rows separator ), 4// The row index you want to retrieve ).Value, " " // The column values separator ), 4 // The column index you want to retrieve ).Value
I hope it helps!
This helps but how can I get just row two extracted from field textinput1.text? The information that will be showing up in textinput1.text will change with every use of this reporting tool. Thank you for all the work you put into this.
I got it 🙂
Well done!! 👏👏
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 914
11manish 617
Valantis 598
