Hope someone had an idea,
lets say i had a data
aaaa,***123,***bbbb,****, *******,cccccc,**ddd,**192939,****,23414,
jsdfh,4355, sgsg,s,sgsg,ssgsg, fdf, 234325, , 32235,
jsdfh,4355, sdsg,s,sgsg,sggsg, fdf, 23432df5, , 32235,
jsdfh,4355, ssg,s,sgsg,sggsg, fwerdf, 234325, , 3235,
jsdfh,4355, ssg,s, ,gsg, fdf, 234325, , 32235,
jsdfh,4355, ssg,s,sgsg,sggsg, fdf, 234325, , 3235,
jsdfh,4355, g,s,sgsg,ssgsg, fdf, 2325, , 32235,
jsdfh,4355, sdsg,s,sgsg,sggsg, fdf, 234325, , 32235,
jsdfh,4355, sg,s,sgsg,sgssg, fdf, 23425, , 3235,
and i need to align all the data according to the data in line one.it must match the coma lines
* is just the empty spacing
How To Align data by coma?
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
-
s_reynisson
- Posts: 939
- Joined: Tue May 06, 2003 1:59 pm
Just one form the hip here as I'm not sure about control characters in prn files, but here goes:
Paste it into Excel (or even OpenOffice?) and then Text-To-Column it. Save it as a prn file (Formatted Text (Space Delimited)). Open the prn file in TP, save it as a txt file and you should then be able to operate on the file in Block Select Mode to your hearts content using the Edit->Fill Block command and delete button. Oh and when in Block Select Mode, first select your range in the first line and then press Ctrl-Shift-End, saves a whole lot of scrolling when working with large files. Hope it helps!
Paste it into Excel (or even OpenOffice?) and then Text-To-Column it. Save it as a prn file (Formatted Text (Space Delimited)). Open the prn file in TP, save it as a txt file and you should then be able to operate on the file in Block Select Mode to your hearts content using the Edit->Fill Block command and delete button. Oh and when in Block Select Mode, first select your range in the first line and then press Ctrl-Shift-End, saves a whole lot of scrolling when working with large files. Hope it helps!
Then I open up and see
the person fumbling here is me
a different way to be
the person fumbling here is me
a different way to be
hmm, i still dont get it, this data was actually from excel where i converted it into csv files, then view it with TP, i need to arrange this data according to the coma as shown in my first line sample. I need the coma and the data in lines and in the right spacing so that later the program which i will import to will recognize and able to read them.
do you think you can help me if i sent u a sample?
do you think you can help me if i sent u a sample?
If you are working with CSV files, you should look into CSVeD, a very good (cardware) CSV editor.
See http://home.hccnet.nl/s.j.francke/software/software.htm.
See http://home.hccnet.nl/s.j.francke/software/software.htm.
Here's an outline suggestion:
1. Set up a new Document Class for this need
2. Be sure the screen and print font is monospaced. (I find that Monospac821BT works really well.)
3. Set tab spacing according to your needs.
4. Make a macro to replace all comma-followed-by-any-number-of-spaces with comma-tab.
That should do it.
tcebob
1. Set up a new Document Class for this need
2. Be sure the screen and print font is monospaced. (I find that Monospac821BT works really well.)
3. Set tab spacing according to your needs.
4. Make a macro to replace all comma-followed-by-any-number-of-spaces with comma-tab.
That should do it.
tcebob