Hi; I want to remove special characters in the data, but I tried many methods and examples without success. I want to remove the special number characters in the sample text below. Example Text " (D)①②③④ have proven to have actually manufactured or delivered the product concerned or similar products " "⑴, ⑷, ⑸, ⑹①②④⑤⑥, ⑺, ⑻ the same with the notice above (No.1・6⑴, ⑷, ⑸, ⑹①②④⑤⑥, ⑺, ⑻ " Remove : ⑴, ⑷, ⑸, ⑹①②④⑤⑥ or ①②③④ Can you please add an example?

@umutcankurt maybe you can clarify what you want to see as a result, maybe with a few examples and edge cases. Would the commas remain? [image] Tree Ensemble Learner does not recognize newlines in column names (include/exclude filter does) KNIME Analytics Platform @tims you could use a regex function and a “Insert Column Header” node to clear your variable names. The logic is you remove everything that is not explicitly permitted. In this case a blank is OK. You might edit that to your needs. regexReplace($Column Name$,"[^a-zA-Z0-9 ]","") [image]

@umutcankurt What have you tested? You might want to upload your workflow so far to get better help br

Hi; @mlauber71 Orginal: ⑴ Official in charge of disbursement of the procuring entity : ENDO Kimihiko Director-General of Hokuriku Regional Development Bureau ⑵ Classification of the products to be procured : 17 ⑶ Nature and quantity of the products to be purchased ① 1 Lighting truck (LED lights 20m class, exchange purchase) ② 2 Traffic control sign trucks (LED type, exchange purchase) ③ 6 Snow removing moter graders (exchange purchase) ④ 2 Road sweepers (vacuum type, exchange purchase) ⑷ Delivery Period : ①②④ 28 March, 2025 ③ 25 October, 2024 ⑸ Delivery place : as in the tender documentation ⑹ Qualification for participating in the tendering procedures : Suppliers eligible for participating in the proposed tender are those who shall : (A) not come under Article 70 and 71 of the Cabinet Order concerning the Budget, Auditing and Accounting (B)①② have Grade A, B, C or D on “Selling of products (Vehicles)” in Kanto-Koshinetsu Area in terms of qualification for participating in tenders by Ministry of Land, Infrastructure, Transport and Tourism (Single qualification for every ministry and agency) in the fiscal year 2022/2023/2024 ③④ have Grade A, B, C or D on “Selling of products (Vehicles)” in Kanto-Koshinetsu or Tokai-Hokuriku Area in terms of qualification for participating in tenders by Ministry of Land, Infrastructure, Transport and Tourism (Single qualification for every ministry and agency) in the fiscal year 2022/2023/2024 (C) not be under suspension of nomination by Director-General of Hokuriku Regional Development Bureau from Time-limit for submission of certificate to Bid Opening (D)①②③④ have proven to have actually manufactured or delivered the product concerned or similar products (E)①②③④ have proven to have prepared a system to provide rapid after sales service and maintenance for the products concerned (F) acquire the electronic certificate in case of using the Electronic Procurement System https://www.geps.go.jp/ (G) not be the Business Operators that a gangster influences management substantially or the person who has exclusion request from Ministry of Land, Infrastructure, Transport and Tourism is continuing state concerned (H) obtained a bid manual from the person of ordering directly : ・Person who received tender explanation form from the Electronic Procurement system ・Person who received from the orderer by CD-R or mail (I) other details, by the tender documentation ⑺ Time-limit for submission of certificate : 12 : 00 25 September, 2023 ⑻ Time limit of tender : ①②③④ 17 : 00 31 October, 2023 ⑼ Contact point for the notice : Purchase Section, Contract Division, General Affairs Department, Hokuriku Regional Development Bureau, Ministry of Land, Infrastructure, Transport and Tourism, 1-1-1 Misaki-cho, Chuo-ku, Niigata-shi, Niigata ken, 950-8801 Japan TEL 025-370-6647 ex. 2536 Edit : “ regexReplace($detail$,“[^a-zA-Z0-9 ]”,“”) “ Official in charge of disbursement of the procuring entity ENDO Kimihiko DirectorGeneral of Hokuriku Regional Development Bureau Classification of the products to be procured 17 Nature and quantity of the products to be purchased 1 Lighting truck LED lights 20m class exchange purchase 2 Traffic control sign trucks LED type exchange purchase 6 Snow removing moter graders exchange purchase 2 Road sweepers vacuum type exchange purchase Delivery Period 28 March 2025 25 October 2024 Delivery place as in the tender documentation Qualification for participating in the tendering procedures Suppliers eligible for participating in the proposed tender are those who shall A not come under Article 70 and 71 of the Cabinet Order concerning the Budget Auditing and Accounting B have Grade A B C or D on Selling of products Vehicles in KantoKoshinetsu Area in terms of qualification for participating in tenders by Ministry of Land Infrastructure Transport and Tourism Single qualification for every ministry and agency in the fiscal year 202220232024 have Grade A B C or D on Selling of products Vehicles in KantoKoshinetsu or TokaiHokuriku Area in terms of qualification for participating in tenders by Ministry of Land Infrastructure Transport and Tourism Single qualification for every ministry and agency in the fiscal year 202220232024 C not be under suspension of nomination by DirectorGeneral of Hokuriku Regional Development Bureau from Timelimit for submission of certificate to Bid Opening D have proven to have actually manufactured or delivered the product concerned or similar products E have proven to have prepared a system to provide rapid after sales service and maintenance for the products concerned F acquire the electronic certificate in case of using the Electronic Procurement System httpswwwgepsgojp G not be the Business Operators that a gangster influences management substantially or the person who has exclusion request from Ministry of Land Infrastructure Transport and Tourism is continuing state concerned H obtained a bid manual from the person of ordering directly Person who received tender explanation form from the Electronic Procurement system Person who received from the orderer by CDR or mail I other

I tried many methods tried in the forum, but the problem is that it also edits the date information. I think I will continue as it is in the example I sent now. @mlauber71 @Daniel_Weikert Thanks for help. :+1: I already tried the example you sent, but I wrote it thinking that maybe I could find a better method. Anyway, I will continue editing it as it is.

delete special characters or words

KNIME Analytics Platform

mlauber71 October 4, 2023, 4:30pm 2

@umutcankurt maybe you can clarify what you want to see as a result, maybe with a few examples and edge cases. Would the commas remain?