Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I need to delete or replace the collon(') symbol in listbox, please find attached snapshot for the same.
In the screenshot, the data in red lined box contains ' symbol at the end. I dont want to load the data which has ' symbol. How can I ignore/delete the first two rows of data in the attached screenshot.
How can I do this, please help me....
Thanks,
Ananth
I just tried this script:
Table:
LOAD PurgeChar(Name, Chr(39)) as Name;
LOAD * Inline [
Name
A'Souza
];
Did not give any problem. Are you sure you are using the field name BUSSINESS_UNIT_ID correctly? Can you share the table where you are doing this in the script?
Best,
Sunny
From the Field drop down, select Expression:
And use the expression: =Replace(BUSINESS_UNIT_ID, Chr(39), '')
There are various functions that can cleanse your data
replace(); keepchar(); purgechar()
It is best to do this in the script rather than in the front-end listbox.
Try purgechar(BUSINESS_UNIT_ID, chr(39))
Thanks for your quick responce.
I tried in script like
purgechar(BUSSINESS_UNIT_ID,Chr(39)) as BusinessID,
it gave me field not found error
Did you place the call in the same tables script? the field name should be the exact same name as the one in your screenshot.
I just tried this script:
Table:
LOAD PurgeChar(Name, Chr(39)) as Name;
LOAD * Inline [
Name
A'Souza
];
Did not give any problem. Are you sure you are using the field name BUSSINESS_UNIT_ID correctly? Can you share the table where you are doing this in the script?
Best,
Sunny
Thank you all, i got my answer.
thanks community
Is the field name correct? is is BUSSINESS_UNIT_ID or BUSINESS_UNIT_ID