# Split coordinates

**URL:** <https://forum.dynamobim.com/t/split-coordinates/18726>\
**Category:** Lists-Logic\
**Created:** [February 2, 2018, 11:36am UTC](https://forum.dynamobim.com/t/split-coordinates/18726 "2018-02-02T11:36:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cydkab](https://avatars.discourse-cdn.com/v4/letter/c/8e7dd6/32.png) [@cydkab](https://forum.dynamobim.com/u/cydkab)\
**Post date:** [February 2, 2018, 11:36am UTC](https://forum.dynamobim.com/t/split-coordinates/18726/1 "2018-02-02T11:36:32Z")

</div>

Hi, I manage to split my geometry into pieces, and so, I need to pass the data to excel. Do you know, or have any idea on how to split the coordinates in order to pass the data to Excel in different cells? Every index has a star and ending point and I only want the data in excel to give the Z coordinate.  
For example: What I have:  
[0] StarPoint (X=…;Y=…;Z=1000) EndPoint (X=…;Y=…;Z=1500)

I need to split the coordinates, so in Excel the data can be manipulates.

What I’m trying:  
[0] Z=1000  
[1] Z=1500

[https://imgur.com/Af625mx](https://imgur.com/Af625mx)

---

<div class="post-metadata">

**Author:** ![Fiesta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/fiesta/32/31914_2.png) [@Fiesta](https://forum.dynamobim.com/u/Fiesta)\
**Post date:** [February 2, 2018, 12:05pm UTC](https://forum.dynamobim.com/t/split-coordinates/18726/2 "2018-02-02T12:05:11Z")

</div>

like this

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/8/88451574a5110a4dfb7a7c12d9907bdd6562670f.png)

---

<div class="post-metadata">

**Author:** ![cydkab](https://avatars.discourse-cdn.com/v4/letter/c/8e7dd6/32.png) [@cydkab](https://forum.dynamobim.com/u/cydkab)\
**Post date:** [February 2, 2018, 12:12pm UTC](https://forum.dynamobim.com/t/split-coordinates/18726/3 "2018-02-02T12:12:22Z")

</div>

Yes @Fiesta, something like that. I only have a small problem, in each index there are 2 points, a start and end point. When I try to do that, it wont work

---

<div class="post-metadata">

**Author:** ![cydkab](https://avatars.discourse-cdn.com/v4/letter/c/8e7dd6/32.png) [@cydkab](https://forum.dynamobim.com/u/cydkab)\
**Post date:** [February 2, 2018, 12:38pm UTC](https://forum.dynamobim.com/t/split-coordinates/18726/4 "2018-02-02T12:38:06Z")

</div>

I manage to solve it using “curve end points” and getting the lenght, wich was the purpose of getting the Z axis 😉