How do I get this to work?
I have tried @NoteID but it is padded with NT000... I just want the NoteID...
Basically I have extracted all the attached files to a folder of its NoteID and I need the view to show it so I can fix the link to the document.
I have exported the data to Excel and then going to use excel to create a link to the files.

Answer Wiki

You should use @UniqueID, not NoteID. NoteID is database specific. @UniqueID is good across multiple replicas of a database.

But, to answer the question, Take the characters off that you don’t want, if there is a set pattern to the padding. I have never used NoteID for anything, but something like this may work.

@rightback(@noteid, 5)

This assumes that the padding is always the same number of characters. If not, you will have to be more clever in your formula, checking for NT and finding the number of 0s, then trimming away what you don’t want. You may have to use a formula loop to trim the padding from the beginning of the string until you get a character that is not an N, a T or a 0, then leave the remainder.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: &nbsp

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy