I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

[#1]

[Anil_Babu_Samineni]

What are the sult and Re in your values? Where this data coming from. Would you explain little more

[tajmohamed30]

hi Harasawa,

give a try at the below link

Replace function: Find Multiple strings and replace to blank

[vishsaggi]

Try these in your Load script where you getting those field names

LOAD ....,

        IF(NOT Match(Year, 'sult'), Year)                         AS NewYear,

        IF(NOT Match(MonthNames, 're'), MonthNames) AS Month

FROM yousource;

[#5]

I believe it is from this. This is at the very end but has no values

[vishsaggi]

Can you share your actual script for those fieldnames?

[Anonymous]

You'll want to remove those records from your data.  I'm guessing besides your month and year filters you have an extra 'results' row that doesn't belong.

In your script you'll want to add a where clause to remove it.

Something like

Load *

From YourFile

where not wildmatch(Month,'Res')

;