Load txt into correct excel format

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

Please advice.

Accepted answers

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 😀👍

All comments

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

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	-

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 😀👍

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

Quick Links

Tags

This months top contributors