filtering

[janardhan]

Hi Friends ,

I have data like below table , in that ItemName field having the text with ; (Semicolon) , i need to filter , i need that value without Semicolon

ItemNum	ItemName	Qty
11011	05.11.12 - 05.11.12 - 6404 - abcdefg  - Ondferære timer	23
11022	04.11.12 - 04.11.12 - 7004 - abcdefg  - Ondferære timer	30
11033	05.11.12 - 05.11.12 - 9004 - Statiost vakhold extra   - Timer na	230

Thanks in Advance

Janardhan

[Gysbert_Wassenaar · Accepted solution]

purgechar(ItemName,';') will remove the semicolon. Is that all you need or do you need only the last part of ItemName after the last hypen? purgechar(trim(Subfield(ItemName,'-',-1)),';')

[janardhan]

Hi Wassenaar ,

purgechar(ItemName,';') this function works fine.

Thanks a lot