Re: RE: [geonet] Concatenate strings in Oasis Montaj

edcunion <[email protected]> Wed, 29 Jul 2015 07:53:00 -0700

Would be handy if in Geosoft OM

Exporting a csv to excel and using concatenate then importing the excel file back into OM database gdb how it's been done here quite a few times in the past

Cheers

Sent from my T-Mobile 4G LTE device

------ Original message------

From: Joe McPherson

Date: Tue, 7/28/2015 12:31 PM

To: Geosoft Oasis montaj and Target;

Subject:RE: [geonet] Concatenate strings in Oasis Montaj

Hello Caitlin,

Abraham is correct – Oasis montaj and Target do not have any tools which allow you to concatenate the contents of two channels into a single new channel. His workaround is a good one and what Geosoft Support usually ends up recommending.

I do however have some good news. We are currently working on adding something similar to Excel’s concatenate function into our Channel Math _expression_ Builder. I can’t promise anything at the moment but we are hoping to have it ready for the next major release of Oasis montaj and Target.

Cheers,

Joe McPherson

Geosoft Support

From: Caitlin_gravandmag [mailto:[email protected]] On Behalf Of author.nameemail
Sent: July 28, 2015 12:59 PM
To: Geosoft Oasis montaj and Target <[email protected]>
Subject: RE: [geonet] Concatenate strings in Oasis Montaj

Thank you Abraham. I did not want to have to export but I guess that is what I will do. This seems like a very basic function that should be included. Dang.

Thanks for your response!

Caitlin

From: AbrahamEmond <[email protected]> [mailto:[email protected]]
Sent: Tuesday, July 28, 2015 10:31 AM
To: Geosoft Oasis montaj and Target
Subject: Re: [geonet] Concatenate strings in Oasis Montaj

I think this would be great feature, I also did not find how to do this, also the refid to a distance command kills text fields including my string Line (annoying).

In Geosoft I had Line not in the data (due to the above error) and a Marker field that was 0 to 7000. In the end I wanted to concatenate Line and Marker to look like this

Line_Marker

A10C_00001

A10C_00500

A10C_06500

B02C_00010

etc.....

To work around this I exported a CSV with line names as data, brought the data into MS access and concatenated using a query. The query SQL syntax is below.

SELECT Table.*, [Table]![Line] & Format([Table]![Marker],"00000") AS Line_Marker

FROM Table;

Then I brought it all back to Geosoft, as this was just one step in larger workflow to assign positions to JPGs. Call if you want a better explanation or need help

-Abraham 801 839 4127

On Tue, Jul 28, 2015 at 7:48 AM, author.nameemail <[email protected]> wrote:

Can you concatenate the contents of two channels into a new channel in Oasis Montaj? I have a line channel and a station channel, I want a new channel to be Line_Station, like 23_100. I cannot find the syntax to do this.

Caitlin Bernier- GISP

Magee Geophysical Services LLC

[email protected]

---

Forum archives can be accessed here: http://lyris.geosoft.com/read/?forum=geonet