Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ChriUwe]

Example:

This is My Song [xxxx xxxx]

How can I only show the text for "title" in square brackets in bold  ?

[mark_h]

One simple solution:

Code: [Select]

=replace(replace([name],/#[#/,/#<b>[#/),/#]#/,/#]</b>#/)
Either use an expression column to replace the [name] column, and use this code as the expression.

Or you could create a user field, eg 'My Name' and use this code as the expression for the field.

Could also be done with regex() function, but would be more complicated, and possibly less efficient. 

The big problem with all such manipulations is the possibility of cases that "break" the code and you end up with either wrong results, or an ever increasing complexity of the expression...

[ferday]

well i think a much simpler and harder to break expression (for your specific example) would be to paste this in an expression column or field

Code: [Select]

=<b>/[[name]/]</b>

[mark_h]

Wouldn't that result in:

[This is My Song [xxxx xxxx]]

?

[ferday]

 

i don't usually understand most of the (poorly written IMO) examples posted here.  so he has a song that has square brackets somewhere in the title, and he only wants that part in bold?  i thought that was his example song title.

ugh, my bad.  good work mark h

[mark_h]

Hehe, I know what you mean.  Hopefully, between us, we've covered both options!

[ChriUwe]

Thank you for your answers!

So I would like it 

My titles:

- All Along the Watchtower [Live] -------> All Along the Watchtower [Live]
- Changes [Dub] ------->                        Changes [Dub]
.
.
.
and so on 

Does somebody has any idea?

[mark_h]

See my answer above...

[ferday]

Thanks for posting a much clearer example!

Mark_h posted a working model, a complicated regex might be more robust but it could get funny trying to account for all the possible breaks.  Try his and see if/where it fails on you and we can try to help with that

[ChriUwe]

Thank you for your efforts. I have tested the expression of mark_h. It works !!!