Importing Data via Script - Assign Column as Text (Minitab)

O

omegab

#1
Hi,

I have a script with something like:

Name C1 "Batch" C2 "Date" C3 "Item"
Read 'Batch' 'Date' 'Item';
FILE "C:\data.txt";

I have a problem where if the Item column initially has rows with numeric values that Minitab assigns the column as Numeric and complains then if it finds some text entries.

How can I define column types using Name? I tried C3-T but that doesn't seem to work?
 
Elsmar Forum Sponsor
O

omegab

#2
Re: Importing data via script - assign column as text

Problem solved... TEXT C2 C2 will turn C2 into a text column
 
O

omegab

#4
Hi again,

Actually the TEXT command didn't work as it won't work on an empty column... I had to actually put in an row in the beginning work with a numeric or text value for each column and then "Delete 1 C1-C10" to remove the row before doing any calculations.

I couldn't find a better way? I'm reading TAB separated data from a file.
 
Thread starter Similar threads Forum Replies Date
D Importing a general wellness low risk product Other US Medical Device Regulations 3
I Importing prototype without CE (dos and don'ts ) EU Medical Device Regulations 11
S Importing Medical devices class I in EU Other Medical Device and Orthopedic Related Topics 5
O Importing a Medical Device into the US from abroad 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 13
M Importing a Registered Class II Device, the Applying Our Label - Need New 510(k)? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
F Mexico Medical Device Importing and Servicing Other Medical Device Regulations World-Wide 2
ScottK Importing medical device for use in fit testing of packaging Other US Medical Device Regulations 3
M Importing medical devices to EU, Germany EU Medical Device Regulations 6
M Importing a Demo Medical Device into the US US Food and Drug Administration (FDA) 3
J Requirements for Importing Research Use Only Medical Devices into Japan Japan Medical Device Regulations 1
J Importing a Finished Medical Device from China (tooth whitener w/ peroxide) China Medical Device Regulations 2
W What Information is provided when Importing Products into USA US Food and Drug Administration (FDA) 1
T Importing Non-Electromedical Device (PACS Software) into South Africa Other Medical Device Regulations World-Wide 2
S Importing a DC motor to UK that is less than 50VDC CE Marking (Conformité Européene) / CB Scheme 11
P Requirements for Importing Hydrocolloid Bandages into the US from China Other US Medical Device Regulations 2
Q FDA Registration and Importing Medical Device Components 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
M South Korea Importing Rules for Privately Labeled Medical Devices Advice wanted Other Medical Device Regulations World-Wide 5
N Importing Diagnostic kit from US, UK Other Medical Device Regulations World-Wide 5
B Class I Medical Device Importing for OEM Requirements EU Medical Device Regulations 3
A Importing Sample Medical Devices into South Korea ISO 13485:2016 - Medical Device Quality Management Systems 2
M Importing Material before the 510(k) is Approved 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
M Importing CE marked Syringes Into the US Other US Medical Device Regulations 2
I Importing Medical Devices into the USA from Germany (Drop Shipments) US Food and Drug Administration (FDA) 2
D Importing Class II Male Latex Condoms From China to US Other US Medical Device Regulations 2
L Importing exempt Class I device from non-registered manufacturer 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
R Importing Breathalyzers into the USA 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
Stijloor Importing Address Books (Thunderbird and Outlook Express) into Windows Live Mail After Work and Weekend Discussion Topics 3
G Importing Medical Device Software to India - Diagnostic Imaging Application Other Medical Device Regulations World-Wide 8
L Importing CSV (comma separated values) / Excel process steps into Visio diagram Excel .xls Spreadsheet Templates and Tools 2
S Exporting then re-Importing 510(k) device 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
S Regulations for importing an IVD diagnostic test in India Other Medical Device Regulations World-Wide 16
bio_subbu CDSCO?s checklist on importing non-critical IVD products in India Other Medical Device Regulations World-Wide 1
amjadrana Importing Medical Devices with Computers as part of the device in Turkey Other ISO and International Standards and European Regulations 1
D Medical Device Regulations - Importing to Singapore - Orthodontic brackets Other Medical Device Regulations World-Wide 5
D How to obtain NOC from DCGI (Drug Controller General of India) for importing drugs Manufacturing and Related Processes 6
G Portocal II - Importing procedures Calibration and Metrology Software and Hardware 2
H Regulation in Australia - Importing medical device (class IIa as per MDD 93/42/EEC) ISO 13485:2016 - Medical Device Quality Management Systems 3
S Eudamed data fields EU Medical Device Regulations 0
J Need Help with FPY Data in Assembly Process Manufacturing and Related Processes 7
Q AMS 2750 E or F Continuous Furnace TUS Data Collection AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
M Reduce occurrence rating based on the PMS data and customer complaint data ISO 14971 - Medical Device Risk Management 2
J Customer Complaint & SCAR, false data Nonconformance and Corrective Action 14
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
D Safety data sheets software REACH and RoHS Conversations 2
M Data Protection and Privacy Policy - looking for a template/example EU Medical Device Regulations 1
S Non parametric test for semi-quantitative data. Statistical Analysis Tools, Techniques and SPC 5
M Disabling measurement data during fault conditions IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
C EU MDR - Annex II 6.1 Pre-clinical and clinical data EU Medical Device Regulations 4
P Ppk results shown as asterisk after the transformation of Non-normal data Using Minitab Software 4
lanley liao How to correctly understand the bullet list d) of 6.3 Analysis of Data for API Spec Q1 Oil and Gas Industry Standards and Regulations 7

Similar threads

Top Bottom