Import Data Table and header has two lines

Help Studio
, ,
1

I am importing an excel file into a Data Table. The header on one of the columns has two lines of text within one cell. When I import that into the Data Table it bring the header in with the return in the header. Does anyone know how I can use that header in an assign variable when it contains the return???

2

just rename the column name after read range and remove the line break

YourDataTableVar.Column(IntIndex).ColumnName =
YourDataTableVar.Column(IntIndex).ColumnName.Replace(vbLf,"")
when not working also try vbCr vbCrLf

Feel free to dynamize it and change all cols within a loop

3

What do I use for IntIndex??? Might be a silly question, sorry.

4

it is 0 based e.g. for the second column we are using 1

1 Like
5

Got it. How can I put it into a loop to change all the columns???

6

for each Activity (not the for each row activity) item in YourDT.Columns | TypeArgument: DataColumn

  • Assign Activity: item.ColumnName = item.ColumnName.Replace(vbLf,"")
1 Like
7

@ppr you are the best!!! Thank you very much!

8

If I have information in a data column, say 5570, and I need that information to be 8 digits with leading zeros, 00005570, is there any easy way to do that?

9

grafik
YourStringVar.PadLeft(8,"0"c)

1 Like
10

And if I was doing it the opposite way…00005570 to 5570, is there a command to do that?

11

give a try at
grafik

12

What if I only wanted to limit it to 6 digits from the right? So 005570

13

now its better that you open a new topic as we prefer to scope 1Topic = 1 case.
Just describe all variations which are to adress there
Thanks

1 Like
14

Ok. Thank you.

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.