Multiple TextBetween?

[Anonymous]

Hi, I have this in my script right now and it is working.

TextBetween(Description, 'JHI_', ' - ') as Abbreviations

What I'd like to do is say

  TextBetween(Description, 'JHI_', ' - ') OR  TextBetween(Description, 'JHI_', ' _ ') OR  TextBetween(Description, 'JHI_', ' . ')  as Abbreviations

However the OR does not work here.  Ideas, suggestions? Please help. Thank you.

[settu_periasamy · Accepted solution]

Hi,

May be you can try with if condition, like

if(not IsNull(TextBetween(Description, 'JHI_', ' - ')),

  TextBetween(Description, 'JHI_', ' - '),

  if(not IsNull(TextBetween(Description, 'JHI_', ' _ ')),

  TextBetween(Description, 'JHI_', ' _ '),

  if(not IsNull(TextBetween(Description, 'JHI_', ' . ')),

  TextBetween(Description, 'JHI_', ' . ')))) as Abbreviations

[sunny_talwar]

Not sure, but this might also work:

Alt(TextBetween(Description, 'JHI_', ' - '), TextBetween(Description, 'JHI_', ' _ '), TextBetween(Description, 'JHI_', ' . ') as Abbreviations

[jagan]

Hi,

Try with Alt()

  Alt(TextBetween(Description, 'JHI_', ' - '), TextBetween(Description, 'JHI_', ' _ '), TextBetween(Description, 'JHI_', ' . ')) as Abbreviations

OR with If() like below

If(Len(TextBetween(Description, 'JHI_', ' - ')) > 0, TextBetween(Description, 'JHI_', ' - '),

If(Len(TextBetween(Description, 'JHI_', ' _ ')) > 0, TextBetween(Description, 'JHI_', ' _ '),

If(Len(TextBetween(Description, 'JHI_', ' . ')) > 0, TextBetween(Description, 'JHI_', ' . ')))) AS Addbreviations

Hope this helps you.

Regards,

Jagan.

[preminqlik]

ALT() is good as per jagan

[Anonymous]

alt did not work. what is alt?

[sunny_talwar]

Then I would suggest going with the second option listed by Jagan.

If that still doesn't work, I would suggest providing a sample to work with.

[Anonymous]

This worked, thank you

[Anonymous]

Hi so I have another column where I need to search for keywords.   For example in this column, Short Description, I need to find the name application however the cells are populated differently.

1. application account updated.

2. The issue was application.

3.  application has been updated.

I need to extract the word application.

Thoughts? Thank you.

[settu_periasamy]

Hi,

You can try with WildMatch.. like

if(WildMatch(Short Description],'*Application*'),Your Expression, False Expression) as FieldName