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,
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,
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 ?
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
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.
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)
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.
I have already set the PreserveFormatting
Property as a True only. But I am unable to get the right format. Thanks!
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
I am able to get it in the format required.
Could you maybe also show us Screenshots of your workflow as to what are the steps taken to perform this ?
Thanks for the response @Rahul_Unnikrishnan
I have tried as you mentioned but the format getting differ.
I have shared my code here
New folder.zip (56.4 KB)
, Kindly check & guide me to fix the first row alignment. Thanks!
@jamunatj ,
Could you show us a Screenshot of your dependencies :
Also Check the below Sample workflow :
Convert_PDF_To_Text.zip (8.9 KB)
@supermanPunch
I have shared dependencies screenshot. Thanks!
I have tested with convert_PDF_To_Text code but facing same align issue.
Hi , I am still facing the alignment issue on text file. Can someone guide me please how to fix the alignment issue.
Thanks!