How to align the first row in text file?

Help Activities
, ,
1

Hi,

I have a text file with no of rows, In that need to align the first row in the text file.
Can someone guide me please , how to align first row?
Kindly refer attachment.
Output.zip (462 Bytes)

Thanks in advance,

2

@jamunatj
are you writing data through write line
if yes then put “\t” 3 value

3

Hi @jamunatj ,

Could you let us know what method are you using to get the data in the non-aligned format ?

Is the Source the Text file itself ?

4

Thanks for the response @supermanPunch.
I need to convert excel data to text file, When i convert excel to pdf file the alignment is good on the converted PDF but when i convert PDF to text file , alignment changed in the first row, Could you please guide me. Kindly refer the attachment.
Output.zip (6.5 KB)

Thanks & Regards

5

@jamunatj ,

Is it possible to provide the PDF file or Excel file as that is the Source Data, and let us know if you are using Read PDF Text Activity to convert to text file.

6

Thanks for the response @supermanPunch

Kindly check the attachment and Yes I am using read PDF text activity to convert text file.
Output.zip (6.5 KB)

7

@jamunatj ,

When using Read PDF Text Activity, have you set the PreserveFormatting Property to True ? If not, Could you check with this property and let us know if you are able to get it in the right format.

image
image847×267 9.94 KB

8

Hi @supermanPunch

I have already set the PreserveFormatting Property as a True only. But I am unable to get the right format. Thanks!

9

Hello @jamunatj

Are you looking for a solution to read from excel and write to a text file?

If yes, from excel you will get the datatable. Then you can use Output datatable activity and convert to string. Then you can use Write Text File.

Thanks

10

@jamunatj ,

I am able to get it in the format required.
image

Could you maybe also show us Screenshots of your workflow as to what are the steps taken to perform this ?

11

Thanks for the response @Rahul_Unnikrishnan

I have tried as you mentioned but the format getting differ.

12

Hi @supermanPunch

I have shared my code here
New folder.zip (56.4 KB)
, Kindly check & guide me to fix the first row alignment. Thanks!

13

@jamunatj ,
Are you using any External Packages ?
image

14

@supermanPunch

I am not using any external packages. Kindly check the screenshot.
Thanks.

Capture
Capture750×505 11.6 KB

15

@jamunatj ,
Could you show us a Screenshot of your dependencies :
image

Also Check the below Sample workflow :
Convert_PDF_To_Text.zip (8.9 KB)

16

@supermanPunch
Capture1
I have shared dependencies screenshot. Thanks!

I have tested with convert_PDF_To_Text code but facing same align issue.

17

Hi , I am still facing the alignment issue on text file. Can someone guide me please how to fix the alignment issue.
Thanks!