Jigsaw research.. replace tabs with carriage returns

For "Tech-heads" nerds, fact seekers, truth seekers, researchers, astronomers and programmers etc.
Post Reply
Ali
Posts: 1
Joined: Sun Apr 09, 2017 11:34 am

Jigsaw research.. replace tabs with carriage returns

Post by Ali » Thu Apr 13, 2017 5:36 pm

Hi, does anyone here know how to convert Jigsaw tables of scores, which are Tab delimited, into MS Excel vertical columns so that graphs can be made easily by pasting a column?

User avatar
aries
Posts: 5
Joined: Sun Apr 09, 2017 11:29 am

Re: Jigsaw research.. replace tabs

Post by aries » Thu Apr 13, 2017 5:51 pm

Ali wrote:
Thu Apr 13, 2017 5:36 pm
Hi, does anyone here know how to convert Jigsaw tables of scores, which are Tab delimited, into MS Excel vertical columns so that graphs can be made easily by pasting a column?
If you have Word, paste the whole table of scores on a new page then do a Find/Replace, with "Find" being ^t and "Replace" being ^l
(That's caret-t for Tab, and caret-l for Line)

So you are telling it "Replace all the Tabs with Line Returns", which immediately puts all your data in a vertical column for pasting in Excel. :idea:

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest