Trim a Field

[evansabres]

Hello -

I have a field that reads Video 123456: Name of Video

I only want the name of the video. How would I trim the field to only return the video name?

Thank you in advance for your assistance.

[shree909]

Hi Use the subfield  function

=subfield('Video 123456: Name of Video',':',-1)  to get right most part

=subfield('Video 123456: Name of Video',':',1)   to get the result as Video 12345 (left most value)

please post a sample file .

Thanks

[antoinelaviron]

Hi,

Try this in the script:

Trim( SubField(Field,':',2)) as Name

Best regards,

Antoine

[MK_QSL]

=SubField(YourFieldName,':',2)

or

=SubField(YourFieldName,':',-1)

or

=Mid(YourFieldName, Index(YourFieldName,':')+1)

[MarcoWedel]

Hi,

I guess Manish Kachhia's solution

Mid(YourFieldName, Index(YourFieldName,':')+1)

might work best because it's the only one that doesn't load e.g. "Mission: Impossible" as just "Mission" or "Impossible".

hope this helps

regards

Marco