How to set Generate Data Table?

Help Activities
, , ,
1

Hi
I have this text content want to write them to excel?
but not sure why the first line (phoneNo) doesnt appear in excel, only show the rest of the content.
also as the text is separated by ; how to do the setting in generate data table? I did in the second picture, but in excel it shows a space line first then next line shows my content. How to fix? Thanks

image

image
image390×949 40.8 KB

2

@koolrc812

Try column separator as ; + Environment.NewLine

Also remove use headers check box else the first line is taken as header, may be thats why your first line is missing

Cheers

1 Like
3

Thanks heaps! it works. but I have multiple text files, when they all write together in excel, theres no new line space in between them, how do I add it?

4

@koolrc812

You can add a blank row before adding new data…

For thta create a table with one blank row and use it before adding thw original data

Cheers

5

but where in generate data table activity has this function?

6

You need to use a build datatable to create a separate table with blank row…

Or one more alternative would be to add a new line in your string

So say the data from text file is str

Then use assign with

Str = ";" + Environment.Newline + str

This will add a new line from generate datatable automatically

Cheers

7

This way? doesnt create a new line.

image

8

@koolrc812

Can you add a blank space before ; " ;"

And also i hope your add header is unchecked

Cheers

9

It Works!!! Thanks heaps! yes the header is unchecked. Appreciated your help!

1 Like
10

Hi @Anil_G
How do I separate them in different cell in excel?
Eg. phoneNo in A1 and 123456789 in A2? then customerId in B1 and 2345678 in B2?
when more text content read, will automatically only write 123456789 in A3, 2345678 B3 etc. let it accumulate keep on going?

image
image310×680 45.5 KB

11

@koolrc812

For that use column separator as = …so tht it splits column on that

Cheers

12

I used this → " = …"+ Environment.NewLine
but doesnt work

13

@koolrc812

Not environment.Newline…

Leave the row separator/newline separator….change the column separator which you gave as "" this to "="

Hope this is clear

Cheers

14

Change to the below?

image
image385×825 39.4 KB

still doesnt separate. Environment.NewLine for me to clear the extra space line, if its not there, the extra space line will be back

15

@koolrc812

For string you will add it…like this

str = " = ;" + environment.Newline + str

And the acreenshot looks proper…

Also your newine separator is guess should be with semicolon and environment.newlineas stated above

";" + environment.newline

Cheers

16

its now separated after = and ;
but customerName=Alex Sam → separated as Alex in cell K1 Sam in cell K2
also would like eg. phoneNo in cell A1 and 123456789 in A2 cause now 123456789 is in B1

17

@koolrc812

Column separator "="

Newline separator ";" + envitonmant.newline

This should work for the shown data

If there are changes please show the new data to verify

Cheers

18

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