Fixed length file from Databricks notebook ( Spark SQL)

[Sadiq]

Hi ,

I need help writing data from azure databricks notebook into Fixed Length .txt.

notebook has 10 lakh rows and 86 columns. can anyone suggest me

[Debayan]

Hi Sadiq, Could you please refer below and check if this helps.

https://k21academy.com/microsoft-azure/data-engineer/reading-and-writing-data-in-databricks/

[Kaniz]

Hi @sadiq vali​ , We haven't heard from you on the last response from @Debayan Mukherjee​ , and I was checking back to see if his suggestions helped you.

Or else, If you have any solution, please share it with the community as it can be helpful to others.

Also, Pledon'ton't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

[Sadiq]

this is not the resolution

[Debayan]

Hi @sadiq vali​ Could you please elaborate a little more what are you expecting about writing data into fixed length.txt?

[Sadiq]

I have data in databrick notebook which is in the form of columns and rows.

now I want to export data from notebook to .txt file with fixed length.

like each column has defined with legth.

support column1 it should occupy only first 10 lenth

[Vidula]

Hi @sadiq vali​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!