Solved: TextToColumn is not working

Hi, I have this csv file to read and i'm using "\0" as delimiter cause when I use the pipe | the input tool doesn't work. Therefore I'm using the TextToColumn tool to try break them into columns but the first column keep having multiplesregister. How can I fix that?

CSV_reader.yxmd

Workflow

Developer

Developer Tools

Input

Preparation

Accepted answers

marcusblackhill

Classic sped! I already work a lot with that files.

Don't configure to input like csv, input like flat file and will work.

Look the example attached.

Hope that works to you!

Reader.yxzp

All comments

atcodedog05

Hi @DanielKimura

You need to provide csv file also to run the workflow and check 😅

Please provide the file we will be happy to help🙂

marcusblackhill

Hey @DanielKimura !

Maybe can be a silly question and sorry for that hehehe but you tried to select and copy the "|" symbol of your data to put in the text to columns instead of type in the "|"?

Some times do that fix the problem.

DanielKimura

Hahahaha that's not silly. Yeah, I've tried but didn't change

DanielKimura

Sorry!! First post, i'm kinda lost

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703