Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Not sure, but this might also work:
Alt(TextBetween(Description, 'JHI_', ' - '), TextBetween(Description, 'JHI_', ' _ '), TextBetween(Description, 'JHI_', ' . ') as Abbreviations
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.
ALT() is good as per jagan
alt did not work. what is alt?
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.
This worked, thank you
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.
Hi,
You can try with WildMatch.. like
if(WildMatch(Short Description],'*Application*'),Your Expression, False Expression) as FieldName