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/

[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!