Txt file formatting

Need help
1

Hi all. I am looking to create a form that captures specific data about a user. The form data needs to been converted into a .TXT file for external reporting requirements. The .TXT file needs to display the data in columns i.e. each column has a maximum character length and position within the file. I’ve attached following image as an example .TXT data structure for demonstration. The first column has a maximum character length of 10 and commences at the position of character 1, the second column is a maximum of 10 characters in length and commences at the position of character 11 etc

image
image1121×656 35.9 KB

I have looked at various plugins as well as using CSV extraction then converting the CSV into a .TXT but I cant find a method that maintains the strict column data structure within the .TXT.

Does anyone have expertise in what I am trying to achieve?

2

Hello, I prepared a test page for you.

Preview

Editor

You just need to change this array as like as you want

const columnLengths = [10, 20, 30, 11, 22, 7, 10] etc.

3

Very helpful tunacardak

4

This topic was automatically closed after 70 days. New replies are no longer allowed.