Load txt into correct excel format

[SCK]

Hi all - I need help in converting txt file into correct excel format. I have attached the input tool for your reference

Please advice.

[Qiu]

@SCK 
You need to give us a sample of desired output.

[SCK]

Output:

Cde	Date	RefOne	Cn/Vn/Wn	Quantity	Val	Unit	Cost	Onhand	Lot/Ser#	Units	Value/Unit	Bin	Number	Units
A/P	8/13/2020		01596763-1	507	0	0.446	13	28
BMV	8/13/2020		1570879 CC	0	13.002	13.002	28	PLT2	-24
TRS	8/13/2020		01362589-1	6	-2	13.002	13	28	T06	-

[atcodedog05 · Accepted solution]

Hi @SCK 

This was a tricky one

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[SCK]

Could you please let me know what reasoning you used behind converting the extension to csv and using \0 as a delimit

[atcodedog05]

Hi @SCK 

File is still a .txt

So "\0" is none delimiter

csv stands for comma separated value. And now separator comma replaced with none.

Which will be helpful parsing.

[atcodedog05]

Happy to help 🙂 @SCK 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂