BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Split a string variable into character and numeric parts
Split a string variable into character and numeric parts

Hi,
I have a string variable (profile) in my dataset which includes prefixes of H, W, B and the suffix numbers ranging from 1 to 1000 (H1, H2, H3, ..., H1000, W1, W2, W3, ..., W1000, etc). How can I split the prefix characters and the suffix numbers into two different parts. I have tried the below code which generates the suffix numbers but not the character part.
Thanks,
NM

gen iteration = regexs(0) if regexm(profile, "[0-9]*$")
destring iteration, replace

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Split a string variable into character and numeric parts
Split a string variable into character and numeric parts

0 Response to Split a string variable into character and numeric parts

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Split a string variable into character and numeric parts Split a string variable into character and numeric parts

0 Response to Split a string variable into character and numeric parts