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 <http://lyris.geosoft.com/read/?fourm=geonet> You are currently subscribed to geonet as: [email protected]. To subscribe or unsubscribe from any of our forums, select the User Forum selection on the Geosoft Community page: http://www.geosoft.com/support/community/forums/register/ --- Forum archives can be accessed here: http://lyris.geosoft.com/read/?forum=geonet <http://lyris.geosoft.com/read/?fourm=geonet> You are currently subscribed to geonet as: [email protected]. To subscribe or unsubscribe from any of our forums, select the User Forum selection on the Geosoft Community page: http://www.geosoft.com/support/community/forums/register/ --- Forum archives can be accessed here: http://lyris.geosoft.com/read/?forum=geonet You are currently subscribed to geonet as: [email protected]. To subscribe or unsubscribe from any of our forums, select the User Forum selection on the Geosoft Community page: http://www.geosoft.com/support/community/forums/register/
