Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

Bulk load object IDs into text mode

Avatar

Level 3

Dear All,

 

I often create reports on various system objects whith use of IDs. Can somone help me understand on how should I get my IDs exported and fomated so I can copy and paste it to text mode? As far as I know I can never get the spaces right. 

 

Kind regards,

Lukasz

 

5 Replies

Avatar

Level 10

Can you paste an example of something you tried that didn't work? So we can see where where the problem may be.

Avatar

Level 3

Hi Randy,

 

It will be difficult to show this with snapshots. 

 

For excample, today I filtered a set of template tasks by which I wanted to identify parallel project tasks. I had approx 200 ids but am unable to correctly trasnposte these from excel export to taxt mode filter. I seem unable to replicate the space between individual IDs in any format: text, excel etc. I am preatty sure it must be format issue but I cant find a way to automate it. I simply want to avoid entering these IDs manually.

 

Kind regards,

Lukasz

Avatar

Community Advisor

I usually export to Excel, copy the column I want, paste that into Word without formatting (so it comes in as lines instead of a table), bulk replace the paragraph breaks with tabs, and remove the tab at the very end of the sentence. That's just me, though.

Avatar

Level 3

Ill try this, hopefully it will also work for me.