Dropping text from a string

[#1]

Hi ... I want to load the below field, 'SALES_NUMBER', but excluding the string 'AB' wherever it exists.

222100

223190

AB224190

AB225190

So output should be :

222100

223190

224190

225190

[sunny_talwar]

Use a Where Statement in that case:

LOAD YourField

FROM Source

Where Left(YourField, 2) = 'AB';

[#3]

Thanks Sunny your answers are spot on as usual. .

Robert I will bear in mind the purgechar function for future ... thanks

[sunny_talwar]

I am glad I was helpful