Convert ASCII to CSV/XLSX

[des118]

Hi friend,

Show me, how can i convert this file (ASCII format) to CSV or XLSX file. It's a raw_file from BSC S15 NSN was sent to Netact:

BSC437116,1,201111150000,60;
53,0,
BTS_ID,53,
SDCCH_SEIZ_ATT,153,
SDCCH_BUSY_ATT,0,
SDCCH_BSS_FAIL,0,
SDCCH_RADIO_FAIL,0,
SDCCH_RF_OLD_HO,0,
SDCCH_RF_NEW_HO,0,
SDCCH_HO_SEIZ,0,
SDCCH_ASSIGN,153,
TCH_HO_SEIZ,1,
TCH_NORM_SEIZ,2,
TCH_REQUEST,3,
TCH_REQ_REJ_LACK,0,
TCH_BSS_FAIL,0,
TCH_RADIO_FAIL,0,
TCH_RF_OLD_HO,0,
TCH_RF_NEW_HO,0,
TCH_QD_CALL_ATT,0,
TCH_QD_HO_ATT,0,
AVE_Q_SEIZ_REQ,0,
QUEUE_DENOM1,180,
AVE_Q_TIM_CALL_ATT,0,
QUEUE_DENOM2,1,


Thanks

[proy1_10]

Hey man this is very easy!!!!
1

Start Microsoft Excel and open an existing file that contains data you'd like to separate. (you can rename to .txt raw data file)
2

Select the all cells containing data you want to separate by clicking and dragging or using the SHIFT or CTRL keys on your keyboard.
3

Click the "Data" tab at the top of the screen to display the "Data" ribbon.
4

Select the "Text to Columns" button to display the "Convert Text to Columns Wizard" dialog box.
5

Choose the "Delimited" selection to separate the data by looking for commas selection to separate the data by looking for spaces. You will be able to see a preview of the selected data below these two choices. Click the "Next" button to move to the next screen of the wizard.
6

Set the column breaks for the selected data by clicking at the point in the preview that you want to add a column. Double-click any column break lines to delete them, and move a break line by clicking and dragging it. Click the "Next" button when you are finished setting the column breaks for your data.
7

Choose a column data format depending on the type of data you are separating, and then choose a destination where you want the new data to appear. (Usually text).
8

Click the "Finish" button to close the "Convert Text to Columns Wizard" and separate the selected cell.

[des118]

Hi man,

DO u have tool for this problem, because i have 1000 files/day, can not do file by file.

[parsarka]

Hi,
Do you have any macro for BSS S15 bsc dump to convert to xls..specially the ZERO,ZEQO,ZEHO & ZEUO

[proy1_10]

Yes, the best option is to do a macro. You can read some introductory book about Excel to do it.
If any problem please post it, this forum is for experts and also for newbies.
If you want to learn you need your own effort

BR