Instead of using CSV, there is also a lesser used format tsv, tab spaced variables.)
Exporting as tsv and then opening in a text editor saves the search and replace part. Andrew -- Sent with K-9 Mail On 21 December 2022 07:45:47 GMT, Tarquin Wilton-Jones via Therion <therion@speleo.sk> wrote: >Step 1 would be to get the data out of Excel and into a text-based >format. Axel suggests copy & paste, which works very well. >Alternatively, in Excel, use "Save as" to save it as a CSV file. Then >open the CSV file in a text editor that has a find-&-replace function, >and replace all commas with spaces. Save the file as something.th > >It's entirely up to you which approach you would prefer. > >Step 2 is to add in the basic Therion wrapper that Axel suggested. > >Cheers, >Tarquin > >> u have to wrap it around some basic Therion code (survey/ centerline). >> As ure question suggest u have not worked before with Therion u might >> want to have a look at one of the dokumentations listet here: >> https://therion.speleo.sk/wiki/doku.php >> u want something like: >> survey 1 >> centerline >> date jjjj.mm.dd >> data normal from to length compass clino left right up down >> 1.1 1.2 7.74 331 3.7 1.9 6.4 2 0 >> (copy&paste) >> ... >> endcenterline >> endsurvey >> in a text file saved as *.th >> as stated before, pls have a look at the dokumentation. There are plenty >> listed: e.g. a step by step one for cavers: >> https://therion.speleo.sk/wiki/tfc >> >> Axel >_______________________________________________ >Therion mailing list >Therion@speleo.sk >https://mailman.speleo.sk/listinfo/therion _______________________________________________ Therion mailing list Therion@speleo.sk https://mailman.speleo.sk/listinfo/therion
