Delimiter at particular column

Hey

I am getting problem to apply delimiter at particular column. My text file consists of delimited data but I want to use delimited tool only on particular column.

• for e.g. 03:30:45 in 1st column and Cellid:dBm in 2nd column. I want to apply delimiter : only at column 2.

Is there any way? Your respected opinions are appreciated.

[Jan]

It is not clear what you are talking about. There are some colons inside "03:30:45" already. How do you create the text file? Why not printing the colon directly?

[Muhammad]

I mean to say i have 2 columns one for time and the NID with dBm. i.e;

Time; NID01: dBm;

16:56:12; 53172; -89;

Now I am importing the text file and applying delimiter. I want to use : delimiter only in 2nd column 1st row. In general when I am using delimiter it is applying in all rows and columns in text file. Like if I am using two delimiters : and ; the result is

Time NID01 dBm

16 56 12 53172 -89

Means it is splitting the time also.

But I am looking for time(16:56:12) in the time column, NID(53172) in NID01 column and value (-89) under dBm column. Is there is any way to use delimiter only in particular row or column(like in our case in 2nd column 1st row). I am using delimiter tool.

Thanks

[Jan]

What does "when I am using delimiter" exactly mean? Please post the code you are talking of. How can a delimiter "applied" during the import?

The example looks strange:

 Time; NID01: dBm;
 16:56:12; 53172; -89;

When these are two columns, why do the 2nd line looks like 3 values?

Posting the code you use, a clear small example for the input and a definition of the output in valid Matlab syntax would stop the discussion and allow for a fast solution of your problem.

[Muhammad]

Please find the attached file. I am using Matlab R2012b. I am importing my file and applying delimiter on the attached imported file. How could I apply delimiter on particular column using column delimiters option.

Answer 1

[Azzi Abdelmalek]

Read all your data with delimiter then recreate the first column.

If

A{1}={'03';'03';'03'}
A{2}={'30';'30';'30'}
A{3}={'45';'46';'47'}

Then

first_column=cellfun(@(x,y,z) [x,':',y,':',z],A{1},A{2},A{3},'un',0)

[Muhammad]

Thanks for your interest.

actually the problem is ;

I mean to say i have 2 columns one for time and the NID with dBm. i.e;

Time; NID01: dBm;

16:56:12; 53172; -89;

Now I am importing the text file and applying delimiter. I want to use : delimiter only in 2nd column 1st row. In general when I am using delimiter it is applying in all rows and columns in text file. Like if I am using two delimiters : and ; the result is

Time NID01 dBm

16 56 12 53172 -89

Means it is splitting the time also.

But I am looking for time(16:56:12) in the time column, NID(53172) in NID01 column and value (-89) under dBm column. Is there is any way to use delimiter only in particular row or column(like in our case in 2nd column 1st row). I am using delimiter tool.

Thanks

[Azzi Abdelmalek]

You can recreate your time array

s='16 56 12 53172 -89'
a=regexp(s,'\s+','split')
time1=[a{1} ':'  a{2}  ':' a{3}]

[Muhammad]

Good idea but the log file that I am tying to import have hundreds of rows and columns. Is there is any method to apply delimiter in particular column by programming or by using tool?

[Azzi Abdelmalek]

If you have a cell array like:

s={'16 56 12 53172 -89';'17 56 12 53172 -90';'18 56 12 53172 -91'}
a=regexp(s,'\s+','split')
time1=cellfun(@(x) [x{1} ':'  x{2}  ':' x{3}],a,'un',0)

[Muhammad]

Thanks for your reply.

Please find the attached file. I am using Matlab R2012b. I am importing my file and applying delimiter on the attached imported file. How could I apply delimiter on particular column using column delimiters option.

[Jan]

I do not see any attached file.