I'm pulling my hair out with this one.
I have a large amount of data recorded from mobile phone base stations, which is in columns.
The equipment we use to measure the base stations spits out an ascii file which uses semicolons as the delimiter....so far so good, UE can cope with delimiters.
The mobile phone companies that we collect this data for want to have the columns in different positions. One company wants the scrambler codes first followed by bit error rates, another wants them at the end, etc etc.
Anyway, I tried recording a macro and started by using UE's "Convert to character delimited fields" which worked great.
Unfortunately this doesn't show up in the macro, which creates a big problem for me.
Secondly, when I use the "cut column" and then paste it into a different position, that also doesnt show up so well in the macro, I just this:
columncut 0
paste
When I run the macro, it doesn't cut and paste any of the columns.
So to summarise, is it possible to create a macro that records "convert to character delimited fields"? and is it possible to cut and paste columns?
many thanks for reading my blurb
I have a large amount of data recorded from mobile phone base stations, which is in columns.
The equipment we use to measure the base stations spits out an ascii file which uses semicolons as the delimiter....so far so good, UE can cope with delimiters.
The mobile phone companies that we collect this data for want to have the columns in different positions. One company wants the scrambler codes first followed by bit error rates, another wants them at the end, etc etc.
Anyway, I tried recording a macro and started by using UE's "Convert to character delimited fields" which worked great.
Unfortunately this doesn't show up in the macro, which creates a big problem for me.
Secondly, when I use the "cut column" and then paste it into a different position, that also doesnt show up so well in the macro, I just this:
columncut 0
paste
When I run the macro, it doesn't cut and paste any of the columns.
So to summarise, is it possible to create a macro that records "convert to character delimited fields"? and is it possible to cut and paste columns?
many thanks for reading my blurb