8da8211f-5729-457f-a9d1-a60a32c626e2 45 4 5 false false 0 decimal

&[DATE] &[TIME] - &[FILENAME]

Handling DATE STRINGS

4 appVersion 0.99.7691.4821

See PROGRAM: 2 for a better method

SAMPLE : DATA

Str_data 1/1/1960 7.9 1/2/1960 34.5 1/3/1960 23.3 1/4/1960 1.5 1/5/1960 0 1/6/1960 0.1 1/7/1960 3.3 1/8/1960 10.1 1/9/1960 5.1 1/10/1960 21.8 1/11/1960 14.9 1/12/1960 6.6 122 mat :

PROGRAM: 1: Read DATA : YEAR / MONTH / DATE  in String Format and VALS in Number Format.. VECTORIZE FUNCTION S USED data Str_Data data eval str data 1 col : vals data 2 col : a str / strsplit vectorize : yr a 3 el vectorize : yr yr 14 substr vectorize : yr yr str2num vectorize : mth a 1 el vectorize : mth mth str2num vectorize : date a 2 el vectorize : date date str2num vectorize : yr mth date vals augment eval 121 line :

SAMPLE Calculation

n 3 :

str1 Str_data 1 col n el : 1/3/1960

vals1 Str_data 2 col n el : 23.3

Using PROGRAM - 1

a1 str1 / strsplit : 13196031 mat

data Str_data Str_Data :

Numeric Data data 196011 7.9 196012 34.5 196013 23.3 196014 1.5 1960150196016 0.1 196017 3.3 196018 10.1 196019 5.1 1960110 21.8 1960111 14.9 1960112 6.6 124 mat

yr1 a1 3 el : 1960

yr1 yr1 14 substr : 1960

yr1 yr1 str2num : 1960

mth1 a1 1 el : 1

mth1 mth1 str2num : 1

date1 a1 2 el : 3

date1 date1 str2num : 3

yr1 mth1 date1 vals1 augment 196013 23.3 14 mat

r 1 Str_data rows range :

c 14 range :

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Alvaro's Method

Δ mat(Str_data r 1 el /, strrep,3,1) concat str2num reverse Str_data r 2 el stack vectorize :

data r c el Δ r 1 el c el : 196011 7.9 196021 34.5 196031 23.3 196041 1.5 1960510196061 0.1 196071 3.3 196081 10.1 196091 5.1 1960101 21.8 1960111 14.9 1960121 6.6 124 mat

Alternative Method 1

aa Str_data 1 col : 1/1/1960 1/2/1960 1/3/1960 1/4/1960 1/5/1960 1/6/1960 1/7/1960 1/8/1960 1/9/1960 1/10/1960 1/11/1960 1/12/1960 121 mat

bb Str_data 2 col : 7.9 34.5 23.3 1.5 0 0.1 3.3 10.1 5.1 21.8 14.9 6.6 121 mat

x nn F x / strsplit nn el str2num vectorize :

Ans aa 3 F aa 1 F aa 2 F bb augment : 196011 7.9 196012 34.5 196013 23.3 196014 1.5 1960150196016 0.1 196017 3.3 196018 10.1 196019 5.1 1960110 21.8 1960111 14.9 1960112 6.6 124 mat

Alternative Method 2: Using PROGRAM: 2

PROGRAM: 2: Read DATA : YEAR / MONTH / DATE  in String Format and VALS in Number Format.. VECTORIZE FUNCTION S USED data Process_Str_Data data eval a data 1 col : (String column ≡ b data 2 col : (Numerical column ≡ x nn F2 x / strsplit nn el str2num vectorize : a 3 F2 a 1 F2 a 2 F2 b augment 51 line :

This vectorize function splits strings at "/" and converts entire matrix to numbers

a 1/3/1960 / strsplit : 13196031 mat

Example

a 1 el 1

a 2 el 3

a 3 el 1960

a 3 el str2num 1960

Data Str_data 1/1/1960 7.9 1/2/1960 34.5 1/3/1960 23.3 1/4/1960 1.5 1/5/1960 0 1/6/1960 0.1 1/7/1960 3.3 1/8/1960 10.1 1/9/1960 5.1 1/10/1960 21.8 1/11/1960 14.9 1/12/1960 6.6 122 mat

Using PROGRAM 2 Str_data Process_Str_Data 196011 7.9 196012 34.5 196013 23.3 196014 1.5 1960150196016 0.1 196017 3.3 196018 10.1 196019 5.1 1960110 21.8 1960111 14.9 1960112 6.6 124 mat