How to make a test data file for the full length of definition?

[MDRI]

How to make a test data file for the full length of definition?
================================================================

Thanks for your replies to my threads.

I am looking to make test data file to satisfy the full length of the field definition.

For instance, with this data structure:

Name varchar (10)
Business Name varchar (15)
Address Varchar (20)

there are many more fields around 70-80 after the above sample

Test file to be with '|' delimiter (field separator)

The output like:

xxxxxxxxxx|uuuuuuuuuuuuuuu|pppppppppppppppppppp

The above is a sample. The fields can be filled with fake characters

If Numeric like number (9,2) with digits

If a character like varchar (20) mix of alphabets & digits

some files use ASCII '\031' as a delimiter.

I tried to do this with excel, I couldn't figure it out. I need forum's guidance.

Are we able to do this with Python code?

How do I do that?

Thanks for your guidance.