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