How to display textbetween in String filed?

[sivaboggarapu20]

Hi Team,

I have filed values like below. I want to display string like 'Snapshot' values from Starting or Ending with Snapshot?

EBS:VolumeUsage

USW2-EBS:SnapshotUsage

EBS:SnapshotUsage

Thanks,

Siva

[m_woolf]

if(index(YourField,'Snapshot')>0,'Snapshot',YourField) as YourNewField;

[sivaboggarapu20]

Hi MW,

It doesn't filtering any data with above expression

Thanks,

Siva

[Chanty4u]

try this

script:

A:

load Test,

if(Test like '*Snapshot*', 1,0) as MyData;

load * Inline [

Test

EBS:VolumeUsage

USW2-EBS:SnapshotUsage

EBS:SnapshotUsage];

Front end:

strighttable:

Dim:Test

Exp:  count({<MyData={1}>}Test)       for   snapshot values result

count({<MyData={0}>}Test)       for non snapshot values result