Icon

kn_​forum_​45697_​change_​blanks_​flexible_​number_​per_​column

replace several blanks with a flexible number of blanks ....

replace several blanks with a flexible number of blanks ....
https://forum.knime.com/t/reduce-the-spaces-between-two-columns/45697/8?u=mlauber71

replace several blanks with a flexible number of blanks ....https://forum.knime.com/t/reduce-the-spaces-between-two-columns/45697/8?u=mlauber71 data1.txtstrip(regexReplace(column("Column1"),"\\s{2,}" ,""))remove multiple blankshttps://forum.knime.com/t/removing-multiple-spaces-from-a-string/11425/10?u=mlauber71Column1_cleanedNode 4control thenumber of blanksto add to each columnColumn1_newNode 7Node 8Node 9run as oftenas theer are blanksseparating strings_process_temp.tabletemporary tableto be overwritten_process_temp.tableposition_blankcolumn_blankswhat to add to the columncolumn_blanks_noColumn_partposition_blanks_idposition_blanks_idposition_blanksadd thevar_colnamerename thecolumnto the current iterationColumn_part=> combine thecontent wiith theindividual number of blanks_process_temp.tableendColumn_part_process_temp.table=> load the combined resultNode 31position_blankcreate uniqueRowIDNode 34SaveIDSaveIDreplace(column("Column1_new"), "#", "")Column1_newresult.tableresult.csv File Reader Column Expressions Column Expressions Table Creator Column Combiner GroupBy Math Formula Table Rowto Variable Counting Loop Start Table Writer Column Filter Table Reader Column Expressions Column Expressions Column Expressions Column Expressions ConstantValue Column Math Formula String ToNumber (PMML) Joiner Java EditVariable (simple) Column Rename Column Expressions Table Writer Variable Loop End Column Expressions Table Reader Column Filter Column Expressions RowID Counter Generation RowID RowID Column Expressions Table Writer CSV Writer Column Filter replace several blanks with a flexible number of blanks ....https://forum.knime.com/t/reduce-the-spaces-between-two-columns/45697/8?u=mlauber71 data1.txtstrip(regexReplace(column("Column1"),"\\s{2,}" ,""))remove multiple blankshttps://forum.knime.com/t/removing-multiple-spaces-from-a-string/11425/10?u=mlauber71Column1_cleanedNode 4control thenumber of blanksto add to each columnColumn1_newNode 7Node 8Node 9run as oftenas theer are blanksseparating strings_process_temp.tabletemporary tableto be overwritten_process_temp.tableposition_blankcolumn_blankswhat to add to the columncolumn_blanks_noColumn_partposition_blanks_idposition_blanks_idposition_blanksadd thevar_colnamerename thecolumnto the current iterationColumn_part=> combine thecontent wiith theindividual number of blanks_process_temp.tableendColumn_part_process_temp.table=> load the combined resultNode 31position_blankcreate uniqueRowIDNode 34SaveIDSaveIDreplace(column("Column1_new"), "#", "")Column1_newresult.tableresult.csv File Reader Column Expressions Column Expressions Table Creator Column Combiner GroupBy Math Formula Table Rowto Variable Counting Loop Start Table Writer Column Filter Table Reader Column Expressions Column Expressions Column Expressions Column Expressions ConstantValue Column Math Formula String ToNumber (PMML) Joiner Java EditVariable (simple) Column Rename Column Expressions Table Writer Variable Loop End Column Expressions Table Reader Column Filter Column Expressions RowID Counter Generation RowID RowID Column Expressions Table Writer CSV Writer Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: A9699459
Created at: 2022-08-04
On NodePit since: 2022-08-08
Last update: 2024-04-27
Created with KNIME version: v4.6.1
Tags: replacestringcolumnexpression

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!