iswope Posted April 21, 2021 Share Posted April 21, 2021 I've Created a custom data Tag. It combines multiple fields into one text string separated by periods. This is the code I use. I created using the Define Tag Field Dialog box. #DB Markers#.#Type#->#DB Markers#.#Type#"."#DB Markers#.#Deck#"."#DB Markers#.#Wing#"."#DB Markers#.#Exhibit#"."#DB Markers#.#Element Number# Is there a way to do a similar thing in a Worksheet? The "Add Custom Field" dialog box doesn't seem to work the same way. I also tried pasting the text from the Data Tag into a custom field. That didn't work either. The photo below shows the Data tag at the bottom and the worksheet above. Ian Quote Link to comment
Pat Stanford Posted April 22, 2021 Share Posted April 22, 2021 =Concat('DB Markers'.'Type', '.', 'DB Markers'.'Deck') Concat is short for Concatenate and is used to combine multiple strings together. It is also smart enough to convert numbers into strings to combine them. Each bit of text is separated by a comma. Litteral strings (things you are typing in) need to be surrounded by single quote marks. In the example above that is '.' (Single quote, Period, Single Quote). Records are identified by the Record Name period Field Name. 'DB Markers'.'Type'. It is good practice to use single quotes around the record and field names, but it is not required unless the contain a space character. A simple test to try is to type text into cells A, B, and C. I am assuming row 3. Set the formula for cell D3 to =Concat(A3, B3, ' ', C3) and see what that does. Ask again if this is not clear enough. 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.