I have a datatable which has leading and trailing whitespaces. I want to remove them but not the ones in the middle.
For eg: " Column 1 " to “Column 1”
try this
ListA=(From p in dt.columns.CastOf(System.Data.DataColumns)
Select Convert.ToString( p ).Trim).ToList
You will get the column names without spaces.
Regards,
Mahesh
Hi @MAHESH1 : Thanks but I am reading an excel file then inserting a For Each Row loop and inside the loop, applying an IF condition, pl. see below: I only want to trim the column name in IF condition, how should I do that:
If CurrentRow(“Turn Over - ZNA”).Equals(“”) Then …
so should I trim the column name in IF condition or just after reading the excel file with Read Range Activity? Below is the screenshot:
Hi @jeevith : I am reading an excel file then inserting a For Each Row loop and inside the loop, applying an IF condition, pl. see below: I only want to trim the column name in IF condition, how should I do that:
If CurrentRow(“Credit Turn Over - ZNA”).Equals(“”) Then …
Here is the column name is “Credit Turn Over - ZNA” and it has a leading and trailing white spaces in excel. So, I want to remove before proceeding further.
Hi @Dr_Raza_Abidi_PhD !
I think that the best strategy would be that just after the read range, you Trim all the column names.
Here is a suggestion to do so: Remove spaces in headers.xaml (8.5 KB)
Beware: this option won’t work if you have 2 identical column names (after the trim)
Let us know if it does not work as expected
@Hiba_B : Thank you very much for your swift response. I have tried the same but in the assign activity, it does not select the ColumnName. Here is the screenshot:
It does not give show the col.ColumnName method in the list.
Hi @Dr_Raza_Abidi_PhD ,
Could you select the TypeArgument to System.Data.Datacolumn to resolve the issue. thanks.
Hi !
In the foreach properties, change the type argument to system.data.datacolumn: then it will appear
item.Columnname = itemColumnname.trim()
Dont forget to configure the typeargument of the for each to the datatype System.Data.Datacolumn
Refer the steps highlighted by @kirankumar.mahanthi1
Thank you.
Thank you so much @kirankumar.mahanthi1 : Now the code is running but the following error occurred during execution.
Still facing issues on this? Thank you.
Could you pls mention which activity it is throwing the mentioned error to troubleshoot to further. thanks.
For Each Activity is throwing exception where I am removing whitespaces from the headers of columns. Thanks,
Can you please debug the code little more deeper? the code is working for me,
Thank you.
@Jobin_Joy : Pl. find below the screenshot: In my excel file, there is a column highlighted in yellow, throwing an exception. Pl. guide what to do?? Many thanks,