Suzhou High-end user file processing

Cat User6.csv|awk ' begin{fs= ', "; ofs=" | "} {print $1,$2} ' >user_consu6.csvcat Consu6.csv|awk ' begin{fs= "|"; O Fs= "|"} {if ($ <=5) print $} ' >user_consu6.csv sed ' s/\./|/g ' user_consu6.csv>user6.csv

CREATE TABLE User_comsu6 (

MDN Char (18),

Chag_earn decimal (6,2))

Load Table User_comsu6 (

Mdn ' | ',

Chag_earn 0x0a)

Using file '/XWTEC210/DATA/WLAN/USER060AA '

Escapes off

Quotes off

Go

Cat User7.csv|awk ' begin{fs= "|"; O Fs= "|"} {print $1,$2} ' >user_consu7.csvcat Consu7.csv|awk ' begin{fs= "|"; O Fs= "|"} {if ($ <=5) print $} ' >user_consu7.csvsed ' s/\./|/g ' user7.csv>user_consu7.csv

CREATE TABLE User_comsu7 (

MDN Char (18),

Chag_earn decimal (6,2))

Load Table User_comsu7 (

Mdn ' | ',

Chag_earn 0x0a)

Using file '/xwtec210/data/wlan/consu7.csv '

Escapes off

Quotes off

Go

Suzhou High-end user file processing