Import txt file

Options
rbitente
rbitente Member ✭
edited August 2023 in ? Transforming data

Hey guys,

I am trying to create an api to import txt to xano and I am facing a issue because xano is removing the extra blank spaces and I need all the spaces to be able to convert this information after.

How can I do it ? because each customer of mine have different formats and they cannot changed it.

Ex of line in txt:

69926 7891203068019 BRIOCHE PANCO TRANCADO 250G TRAD 00000000084920230309 000010004_MERCEARIA SECA DOCE
69927 7896200115025 FEIJAO RAJADO BROTO LEGAL 500G 00000000073920230309 000000002_COMMODITIES

Where i need to split after not by the space but by the collumns ! Ex: 00000000073920230309 here will be splited in 3 diferent informations.

This files have more the 60K lines.

· Share on Twitter

Best Answer

  • Liz Anaya
    Liz Anaya Member, Administrator

    ADMIN
    Answer ✓
    Options

    Hi @rbitente,

    Welcome to the Xano Community! 🥳

    The extra spaces will not be shown on the table or the debugger on Xano. This doesn't mean that they have been removed. I recommend testing using a tool like Postman, which will show extra blank spaces, to see how the data is being saved.

    Let me know if this answers your question or if you have any additional questions. 😊

    · Share on Twitter

Answers

Categories