vincentBsef Posted March 25, 2021 Report Share Posted March 25, 2021 Hello, I want to copy the first column of my DTI in an array. The column type is STRING-ASCII. But it seems i canot create an array of STRING. I am right, or i am missing somthing ? I'm starting to thing that a STRING, is alreay a kind of array. Thank you. Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted March 26, 2021 MVP 2023 Report Share Posted March 26, 2021 I checked it and you are right - Array is not an option for for the String tag type. I would do it the hard way and make a large Buffer array and manually track my string locations. I realize this is a PITA, but you have to work with the tools you have. Joe T. Link to comment Share on other sites More sharing options...
vincentBsef Posted March 26, 2021 Author Report Share Posted March 26, 2021 Thank you for your answer. I got around the problem by getting my information another way. I read line by line, and test the cell with the string, line by line. It works. vbs Link to comment Share on other sites More sharing options...
Swervomotor Posted March 30, 2021 Report Share Posted March 30, 2021 If you are are looking for a value in the table you can use find DTI Column Value. Not sure if that's what you mean with line by line. -Swervomotor Link to comment Share on other sites More sharing options...
vincentBsef Posted March 31, 2021 Author Report Share Posted March 31, 2021 Hi Swervomotor. Thank you for the answer I'll see it will help. Link to comment Share on other sites More sharing options...
vincentBsef Posted March 31, 2021 Author Report Share Posted March 31, 2021 In fact, I can't use this block for the purpose I required. Because I also have to count the number of previous lines that do not contain the STRING, in addition to noting the line number (from bottom to top). But, I need it for another use, in which... this is exactly what ... I need. So, that's cool. Link to comment Share on other sites More sharing options...
Swervomotor Posted March 31, 2021 Report Share Posted March 31, 2021 It is very handy, also Find DTI Column Value outputs the row number (F). If the value was "2" and the rows start at "0" that would mean it checked n=n before it found the value and n+1 when if found the value. -Swervomotor Link to comment Share on other sites More sharing options...
vincentBsef Posted March 31, 2021 Author Report Share Posted March 31, 2021 Yes. Tat's clever. Have to admit : hadn't thought of that. But i need to start at the end. And, i have to exclude the empty lines before. Excluding empty row is checking for zero (in one specifique cell that canot be 0 if not empty). So, Find DTI Column won't work. But one the first unempty row find, using that block is lighter, smarter. Must be folow by a sub, though. I will keep it the way i wrote. But I already used this since I read your answer And i probably should have do it before. VB Link to comment Share on other sites More sharing options...
Recommended Posts
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