I am administrative units, need to use SQL2008 big data analysis, a CSV file of more than 1000 ten thousand records, more than 20 G, Chinese field have a lot of Spaces, with execl tried len formula, the blanks are the longest in the 1000 field, as shown in figure,
If not cleared space this 20 g file imports SQL2008, query and prompt when insufficient storage space (where the partition with 500 g, the remaining 110 g), if you need to remove the blank space in any way faster, is really no way, is there a great god can help

CodePudding user response:

ID and record nature, NO, the actual Banks, record state, serial number, the affiliate of the father, father, prices, more patient, billing ID, patient ID, page ID, ordered sequence number, clinic signs, entry fees, name, gender, age, identification number, bed number, the patient ward ID, name, ward patients, patient department ID, name of patient department, fees, fees category, charge breakdown ID, name of charge breakdown, calculating unit, pay the number of pills, window, several times, to work overtime, additional symbol, the baby, income project ID, project name, income receipt fee item, standard unit price, amount receivable, paid-in amount, price and billing department ID, name, billing department open singles, time of occurrence, the registration time, enforcement ID, name of enforcement, execution, execution status, execution time, the conclusion that the operator number, name of the operator, to settle an account ID, the check amount, insurance categories ID, NO insurance project, insurance code, expense type, as a whole, whether the upload, summary, whether emergency
-- -- -- -- -- -- -- the first data -- -- -- -- -- -- -- --
72****73,2,T0640919,,3,4,,,0,,1249694,1,28451007,2,1,张三 ,女 ,67岁 ,201****72,10 ,67,二内科 ,67,二内科 ,普通 ,5,9561,丹参川芎嗪注射液 ,支 ,1,,2,0,0,0,118,西药费 ,西药费 ,30.38,60.76,60.76,,67,二内科 ,龚建荣 ,2019/**/25 12:00:00.000,2019/**/25 08:40:28.000,93,住院西药房 ,,0,,,0054 ,李四 ,7432078,60.76,536,0,86903282000136 ,,0,1,丹参川芎嗪注射液 5ml*5支 ,
-- -- -- -- -- -- -- the second data -- -- -- -- -- -- -- --
72****74,2,T0640919,,1,2,,,0,,1249694,1,28450697,2,1,张三 ,女 ,67岁 ,201****72,10 ,67,二内科 ,67,二内科 ,普通 ,5,9800,葡萄糖酸钙 ,支 ,1,,2,0,0,0,118,西药费 ,西药费 ,13.2,26.4,26.4,,67,二内科 ,龚建荣 ,2019/**/25 12:00:00.000,2019/**/25 08:40:28.000,93,住院西药房 ,王五 ,1,2019/**/25 10:11:28.000,,0054 ,李四 ,7432078,26.4,535,0,86902662001718 ,,0,1,葡萄糖酸钙 10ml:1gX5支 ,

CodePudding user response:

If the import is successful, it is just a query, can do it there will be space field space, use the RTrim () function can, for example:
nullnull