string processing

[Peony]

Hi All

I have such dataset

LOAD * Inline [

Name,                Sign 
WIND-SEP19,    W
WIND-OCT18,   W
WIND,                  W
WINDY,                 D
];
 I need to process each row with the next logic:  if  there is a "-" I need to  replace Name field value till this sign.  
As the result I will have the next table 

LOAD * Inline [

Name,                Sign 
WIND,                  W

WIND,                  W

WIND,                  W

WINDY,                 D
];

Coud you, please, tell how to apply such logic it in the load script?

[Anil_Babu_Samineni · Accepted solution]

Try this? 

LOAD * Inline [

Name, Sign
WIND-SEP19, W
WIND-OCT18, W
WIND, W
WINDY, D
] Where Not WildMatch(Name, 'WIND-*');