I have extracted some data from a text file. I have managed to display the
extracted data in columns in the ListBox. Except for the data in the first
column, the data in the other columns are out of alignment with the column
headers. How do I align the data with the column headers?

Any help is very much appreciated. Thank you.

I don't know how you got the data into the listbox but you probably have
extra blnk spaces (or other invisible charaters) at the beginning or end of
the data. doing a RIM() of the data before putting the data into the listbox
will remove the blanks but not the other white characters like TAB. Without
seeing you code I cannot give you a complete solution.

"Francis Ang" wrote:

I have extracted some data from a text file. I have managed to display the
extracted data in columns in the ListBox. Except for the data in the first
column, the data in the other columns are out of alignment with the column
headers. How do I align the data with the column headers?

Any help is very much appreciated. Thank you.

Thank you very much Joel. I will try your suggestion.

"Joel" wrote:

I don't know how you got the data into the listbox but you probably have
extra blnk spaces (or other invisible charaters) at the beginning or end of
the data. doing a RIM() of the data before putting the data into the listbox
will remove the blanks but not the other white characters like TAB. Without
seeing you code I cannot give you a complete solution.

"Francis Ang" wrote:

I have extracted some data from a text file. I have managed to display the
extracted data in columns in the ListBox. Except for the data in the first
column, the data in the other columns are out of alignment with the column
headers. How do I align the data with the column headers?

Any help is very much appreciated. Thank you.

Hi Joel

I've looked but haven't found: What is a RIM() ?

Thanks,

Dan

I'm guessing TRIM.

dan dungan wrote:

Hi Joel

I've looked but haven't found: What is a RIM() ?

Thanks,

Dan

--

Dave Peterson