
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Purgechar ##65#
Hello All,
I would like to know if the below will remove only the '##65#' or all '#', '6' and '5' values?
PurgeChar(ABCD, '##65#')
I need to remove just the '##65#' from my column ABCD.
Many Thanks,
Hasvine
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Hasvine,
Yes. It will remove '#', '6' and '5' from your field. You need to use replace function in this case.
Replace(FieldName, '##65#', '')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Hasvine,
Yes. It will remove '#', '6' and '5' from your field. You need to use replace function in this case.
Replace(FieldName, '##65#', '')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
aa:
LOAD * INLINE [
ABCD,sales
a##65#, 1
abbb##65#, 2
##65#b, 3
c##65#, 4
d, 5
];
LOAD *,
PurgeChar(ABCD,'#65') as new
Resident aa;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi hasvine
It will remove all the '#', '6' and '5' values. Better use replace(ABCD, '##65#','').
Regards
Pratyush
