[Therion] convert excel to therion
Andrew Atkinson
andrew at wotcc.org.uk
Wed Dec 21 09:21:19 CET 2022
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 at 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 at speleo.sk
>https://mailman.speleo.sk/listinfo/therion
More information about the Therion
mailing list