Txt\string to datatable

Help Studio
,
1

Hi All

How can I transfer data from a text format to a table in the same form as the original?
Screenshot_3 ------> Screenshot_4

The problem is that it ignores deserts cells and leaves only 3 values
Screenshot_5

2

@Aibek_Abubakirov

Check attached

testtttt.zip (23.1 KB)

Mark as solution if this helps

Thanks

3

but how to get rid of extra lines?

4

@Aibek_Abubakirov

as you said below

Screenshot_4

It will create by leaving the spaces exactly

Can you share sample excels and the output you require?

Thanks

5

test.txt (54 Bytes) tessttt.xlsx (8.6 KB)

6

@Aibek_Abubakirov

Check attached

testtttt.zip (54.5 KB)

Mark as solution if this works for you

Thanks

7

image

only one value comes out

8

@Srini84 or can it be done with a Excel macros?

9

@Aibek_Abubakirov

For me it rans fine, you can download below attachment, remove all from excel sheet and try

testtttt.zip (23.4 KB)

check once again

10

I tried, only one value comes out

11

Thanks a lot for the help, I solved the problem using VBA

12

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