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.

Subtract number and character separately from a string variable
Subtract number and character separately from a string variable

I have a string variable (Size) that contains numbers and characters. I want to subtract number and create new_var1 and subtract character and create new_var2. Which code do I have to use to get the results like below? Thank you.

SIZE NEW_VAR1 NEW_VAR2
0.13 AC 0.13 AC
2560 SF 2560 SF
2145 SF 2145 SF
1.12 AC 1.12 AC

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Subtract number and character separately from a string variable
Subtract number and character separately from a string variable

0 Response to Subtract number and character separately from a string variable

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Subtract number and character separately from a string variable Subtract number and character separately from a string variable

0 Response to Subtract number and character separately from a string variable