Ignoring values in Script

[#1]

Hi

Here is my Sample data in a field , I want to ignore the values anything which has text after Payroll:v1/returns/ and  Payroll:v1/submissions/ in the script .. how can I achieve this?

Thanks

Sample Data

Payroll:v1/submissions/

Payroll:v1/submissions/checklimit/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Payroll:v1/returns/numbera2461865320db320153365bd07d11f3/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

Expected Output

Payroll:v1/submissions/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

[sunny_talwar]

May be this:

Table:

LOAD *,

// Index(Field, '/', 2) as Count,

  If(Index(Field, '/', 2) > 0, Left(Field, Index(Field, '/', 2)), Field) as New_Field ;

LOAD * Inline [

Field

Payroll:v1/submissions/

Payroll:v1/submissions/checklimit/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Payroll:v1/returns/numbera2461865320db320153365bd07d11f3/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

];

[#3]

there are these type of values also ,which I still wanted to be .. so I think we have to explicitly mention the values

Payroll:v1/submissions/ and Payroll:v1/returns/

Payments:/case-management-ws/v1/calendarDate

Payments:/case-management-ws/v1/merchant/number/cases/number/documents

[maxgro · Accepted solution]

Table:

LOAD *

where match(Field, 'Payroll:v1/returns/', 'Payroll:v1/submissions/')

or not wildmatch(Field, 'Payroll:v1/returns/*', 'Payroll:v1/submissions/*') 

  ;

LOAD * Inline [

Field

Payroll:v1/submissions/

Payroll:v1/submissions/checklimit/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Payroll:v1/returns/numbera2461865320db320153365bd07d11f3/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

];