Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Extracting using multiple wildcards

Hi,

I'm pretty new to Trello and trying to get my head around Butler and wildcards.

Basically I want to extract various chunks of text from the description when a new card is added / moved and put them into custom fields. I've worked out how to do it OK for one, but I can't see how to do it for 4-7 different fields. 

 

So as an example my description might be 

Name: Bob Smith

Job Title: Manager

Company: Acme Ltd

Order#: 123456

I want to pull the text from each line (after the colon) into a different custom field. I thought if I included some other identifiers, regex style I might be able to pull this off, but seem to be struggling.

Does anyone have any ideas (or a totally different way of doing this?)

Thanks

Matt

2 answers

1 accepted

0 votes
Answer accepted

@Matt Page 

Definitely doable. Make sure you include \n\n for each new line. 

@Matt Page 

For larger dataset, I would suggest using HTTP request to an endpoint. The {httpresponse} will be in key:value pair which you can use it to set the custom field values. You can extend your endpoint to handle the CF updates. 

See https://trello.com/c/ULsKwRLh/43-parse-card-description-for-key-value-pairs-simpl

This is a sample output from Butler console for a more complex card description from a webform from Contalist. It shows the http request from Butler.

Screen Shot 2021-06-23 at 7.49.05 AM.jpg

Thanks, that looks really helpful. I'm still very new to Trello, let alone doing more advanced stuff like this, but I also had a strong suspicion it was possible somehow.

@Matt Page 

It can be done with Butler. You just need to be very careful in building out the command. Here, I am relying more on the structure and using the names (keys like name, address, email etc) instead of hardcoding. It can be use for any card as long as the structure remains unchanged.

0 votes
Iain Dooley Community Leader Jun 23, 2021

@Matt Page you can actually use regular expressions directly in Butler, can you post your existing rule that's working?

@Iain Dooley Sorry it's taken me so long to reply - I sort of forgot about the thread!

So at the moment I have 6-7 rules along similar lines to:

when a card with a description containing "</\>||¬¬{*}<\/>||¬¬" is added to list "engine room", set custom field "Project or BAU" to "{wildcard1}"

But if I put another expression in there I can't get it to work. Ideally I'd be able to have just the one rule that found 6-7 expressions and sent them to 6-7 different rules. But as I say, my method is working, it's just a bit cumbersome.

Matt

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

206 views 2 14
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you