

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to remove required characters from field value
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.
- « Previous Replies
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what about omitting these fields in the load?
LOAD
[Product],[Product Number],[Order],[Order Number] as Field
resindent table;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can use pick and match function.
Thanks,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you be able to share few rows of data to show what you have and what you are looking to get?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please share some data to have a look.
Regards
Anand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Anand,
I shared field "value" in my first post (question).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;

- « Previous Replies
- Next Replies »