Import CSV file and clean data by removing letters

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4 · Accepted solution]

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

[#5]

Thanks a lot. Very apreciate your work.