Hey guys,

I'm trying to get my trimble style sheet to put my atribute before my code in the output.

code= settlement plate condition -->only 8 different conditions      K01

attribute= settlement plate number -->about 250 plates                1206

if i use the standard xls I found i reads 

pt,  code    attr    x           y          z     

1  ,  K01 , 1206 ,  1000,   1000,   ,1000  

but i need it to be 

1,  1206K01 ,1000 , 1000 , 1000. 

removing the comma between 1206 and K01 isn't a problem. thats just using textpad or something similar

having to relocate complete kolloms is to much editing and i would rather have my trimble do that.

thanks in advance.

Lourens Pepping 

This Content Originally Published by a land surveyor to Land Surveyors United Network

Views: 358

See Your Saved Posts Timeline

Replies to This Discussion

Hi Lourens,

I'm not sure about changing the stylesheet, but this would be a simple task in Excel. Export your data to .csv and then use a concatenate function: 

http://office.microsoft.com/en-au/excel-help/combine-two-or-more-co... 

Once you have used the concatenate function on a "separate" column, you can use "paste as value" to save the results permanently into your desired column and this should sort out your problem.

Darren 

Thank you for the information, that should work.

do you also happen to know if it's possible to make a macro in excel (like you can do in notepad) so you just press a button and magic happens?

Hi Lourens,

Yes, you will be able to record a macro to do this. You can read http://support.microsoft.com/kb/213477 . I would suggest that it would be easier to record yourself completing the process with some "live" data, and then saving that file as a template, of sorts.

Then when you have new data, you will need to:

1) Save the new data into a new file

2) Load your "template" file

3) run the macro contained in your template in your new file.

You may have to google this to get a better understanding of what I mean, but the process will be as I have explained.

RSS

Where Thousands of Professional Land Surveyors, Students of Surveying and Educators are United through Collaborative Knowledge and Purpose.

Land Surveyor Forum - Community Discussions

Trimble TTS 500

Started by A.J. Blaker. Last reply by ⚡Survenator⌁ Jul 31, 2018. 8 Replies

Trimble Post Processing

Started by Lord Byron abriz. Last reply by Georgios Adamopoulos Jan 28, 2018. 8 Replies

reuse activation disks?

Started by Carl Sundet Jan 1, 2018. 0 Replies

TGO1.63 problems

Started by Ronald Berry Dec 9, 2017. 0 Replies

TSC2 and R-8 model 3 VRS connection

Started by Ronald Berry. Last reply by Ronald Berry Oct 1, 2016. 4 Replies

Trimble Pathfinder Pro XRS

Started by Stefan Danailov Dobrev Jun 2, 2016. 0 Replies

Trimble Business Center.

Started by Maurice Heter. Last reply by ⚡Survenator⌁ Apr 15, 2016. 3 Replies

RTK vs HP-Omnistar Correction (Quality and productivity)

Started by Yahiaoui. Last reply by ⚡Survenator⌁ Sep 15, 2016. 4 Replies

Trimble Field Link and S8

Started by Tim Seville. Last reply by Maurice Heter Mar 4, 2016. 3 Replies

TRIMBLE 5600 CU REPAIR (GEODIMETER)

Started by CHARLIE B. AYCOCK, III. Last reply by Maurice Heter Apr 14, 2016. 2 Replies

TSC3 SCS900 Advance measurement module. Closing Traverse Loop

Started by Land Surveyor. Last reply by ⚡Survenator⌁ Sep 15, 2016. 3 Replies

Zeiss Elta 50

Started by TROY DANIEL. Last reply by Andy Grigg Aug 19, 2015. 2 Replies

Trimble XRS 2.30 Pro, Pathfinder 4.00

Started by Frank Guld. Last reply by ⚡Survenator⌁ Mar 4, 2016. 1 Reply

TSC3 DATALOGGER CALIBRATION FILE TRANSFER

Started by Stephen Adu Poku. Last reply by Stephen Adu Poku Dec 21, 2014. 2 Replies

attribute display in txt file

Started by Lourens Pepping. Last reply by Darren Noble Dec 20, 2014. 3 Replies

Calibrating a Trimble S8 total station

Started by Darren White. Last reply by ⚡Survenator⌁ Sep 15, 2016. 2 Replies

Trimble 5603 Connection Question

Started by Jason Carter. Last reply by Darren White Nov 21, 2014. 4 Replies

Tools,Apps and Quick Guides

DEDICATED TO THE MEMORY OF SKIP FARROW (1953-2015)


Help With Survey Equipment

Social Support For Equipment

Surveying Video Categories

Surveying Photo Categories

United States Hub Forums

International Surveyor Hub Forums

Resources for Company Owners

Land Surveyor Social Media

Surveyor Resources Collections

Getting Started & Newsletter

Featured Land Surveyor Hubs

Surveyor Birthdays

© 2019   © Created by Land Surveyors United   Powered by

Badges  |  Contact LSU  |  Privacy Policy  |  Terms of Service

Site Explorer