title: Is there anything in mariadb to import data from .txt file or different format where i can define a filed value length from position to position?
body: <p>Trying to import the data in maridadb and my data will look like</p>
  <p>&quot;20220910SATURDAY&quot;
  &quot;20220911MON&quot;
  &quot;20220912TUE&quot;
  &quot;20220913THUR&quot;</p>
  <p>represents the data.
  My database structured columns are :
  column1:Year,
  column2:Month,
  Column3:Day,
  Column4:DayInLetters.
  Need to define a configuration like in every line first 4 letters i.e from 0 to 3 is year field ,
  4-5 is Mon,
  6-7 is Day,
  8-last is DayInLetters.
  Is there any solution?</p>