How to remove required characters from field value

[nihhalmca]

Hi All,

LOAD

   [Product],[Product Type],[Product Number],[Order],[Order Type],[Order Number] as Field

resindent table;

Here i need to remove "[Product Type],[Order Type]" from filed.

I tried purgechare, it removes [Product Type],[Order Type] and all [] and Product(i mean Product, Product from Product Number) from field as well.

Can you assist on this please.

Thanks,

Nihhal.

[Frank_Hartmann]

what about omitting these fields in the load?

LOAD

   [Product],[Product Number],[Order],[Order Number] as Field

resindent table;

[its_anandrjs]

Please elaborate why you use PurgeChar()

LOAD

   [Product],[Product Type],[Product Number],[Order],[Order Type],[Order Number] as Field

resindent table;

Is this your field

   [Product]&[Product Type]&[Product Number]&[Order]&[Order Type]&[Order Number] as Field

Regards
Anand

[Anonymous]

Hi,

You can use pick and match function.

Thanks,

[sunny_talwar]

Would you be able to share few rows of data to show what you have and what you are looking to get?

[nihhalmca]

Simple Sunny.

My direct question is, i want to exclude some chartacters from the field value however those are repeated in fied value.

I hope i explained very clear.

[its_anandrjs]

Please share some data to have a look.

Regards

Anand

[nihhalmca]

Hi Anand,

I shared field "value" in my first post (question).

[sunny_talwar · Accepted solution]

May be use Replace multiple times

LOAD *,

          Replace(Replace(Field, [Product Type], ''), [Order Type], '') as NewField;

LOAD  [Product],[Product Type],[Product Number],[Order],[Order Type],[Order Number] as Field

resindent table;

[nihhalmca]

Hi Sunny, its working with small changes.

LOAD *,

          Replace(Replace(Field, '[Product Type],', ''), '[Order Type],', '') as NewField;

LOAD  [Product],[Product Type],[Product Number],[Order],[Order Type],[Order Number] as Field

resindent table;