topic Re: Import CSV file and clean data by removing letters in Discussions

Import CSV file and clean data by removing letters

NickelNorbert — Tue, 25 Feb 2025 13:49:07 GMT

Hi JMP Community,
I struggle with a csv import. Unfortunatly I get only that weird csv format from my datasource. At the end I want to use actual voltage and actual current and the time as steady values.

Can you please give me some hints how to import the csv correctly?
Thanks in advance

Norbert

Re: Import CSV file and clean data by removing letters

jthi — Tue, 25 Feb 2025 14:06:59 GMT

Use Open with Preview

Then as you seem to have units in the columns, loop over each column+row and clean them and change "," to "." if needed

For removing characters, you can for example try with Recode

Re: Import CSV file and clean data by removing letters

Ben_BarrIngh — Tue, 25 Feb 2025 15:03:49 GMT

Hi @NickelNorbert ,

Just to add on to @jthi 's post, I've put together a Workflow Builder file for you to run on any file type, this works so long as the file structure is the same (same column titles, layout from export) which it sounds like you have.

Essentially I've used the text file import (as @jthi has detailed), brought in the files then recoded using 'Extract Segment' to take the values before the appearance of 'V' and 'A' in your columns, then converted all the character columns to numeric.

I did a few minor changes with JSL to get the Workflow to work on new files, if you're interested in that I can detail that more on this post.

Thanks,

Ben

Re: Import CSV file and clean data by removing letters

NickelNorbert — Wed, 26 Feb 2025 11:55:00 GMT

Thank you very much for the great and detailed help.
Norbert

Re: Import CSV file and clean data by removing letters

NickelNorbert — Wed, 26 Feb 2025 11:56:50 GMT

Thanks a lot. Very apreciate your work.