Find out the field and value from STRING

[sona_sa]

Hi

I have a filed, In which following are the information are available like :

LOCATION - It is start with TestedLocation - Value will be LOCATION NAME - SYDNEY, BANGALORE, BEIJING etc.

OPERATOR - It start with TestEnvironmentSim1, TestEnvironmentSim2 - Value will be AIRTEL, TMO-US, NTT-DCM, VODAFONE etc.

V_AREA - IT start with FT, DFT, OPIOT etc. - Value will be FT, OPIOT etc.

RAT1 - Value be 2G, 3G, 4G, 4G FDD, 4G TDD etc.

RAT2 - Same as RAT1

RAT1MODE - Value be, SINGLE, DUAL MODE, TRIPLE MODE (4G/3G/2G)

RAT2MODE - Same as RAT1MODE

Now the issue is all the field are in single string and some where it start with slash (/), Some where comma (,) and some where blank space.

So can any one make a script to find out entire fileds from the STRING.

Regards,

AK

[sona_sa]

Hi Buddy,

Any solution ? Please ...

[Sergey_Shuklin]

Hello!

There are no comma-separated rows. And how we should handle space-separator with such cases: RAT1Mode:Dual Mode (3G/2G)?

[sona_sa]

Hi Sergey,

RAT1Mode:Dual Mode (3G/2G),  Where RAT1MODE is field and after the :,  Dual Mode (3G/2G) are value.

Regards,

AK

[Sergey_Shuklin]

Like this way?

[sona_sa]

Hi Sergey,

Thanks for reply,

But as I mentioned, There is only - 7 Field available in this one raw, May be there are some raw is available, where entire information is not available, May be either for Field Operator - TestEnvironmentSim2, RAT2 and RAT2MODE  will be not abailable.

Like this :

Flight Mode ON and OFF/MobilityType:Static/RAT1:4G FDD/RAT2:3G/TestedLocation:San Diego/TestEnvironmentSim1:TMO-US/TestEnvironmentSim2:AT&T/RAT1Mode:Dual Mode (3G/2G)/RAT2Mode:Single Mode

FT-RT-RB-1/MobilityType:Static/RAT1:2G/TestedLocation:Hangzhou/TestEnvironmentSim1:CMCC/RAT1Mode:Single Mode

LOCATION - It is start with TestedLocation

OPERATOR - It start with TestEnvironmentSim1, TestEnvironmentSim2

V_AREA - IT start with FT, DFT, OPIOT etc.

RAT1 - Value be 2G, 3G, 4G, 4G FDD, 4G TDD etc.

RAT2 - Same as RAT1

RAT1MODE - Value be, SINGLE, DUAL MODE, TRIPLE MODE (4G/3G/2G)

RAT2MODE - Same as RAT1MODE

Regards,

AK

[sona_sa]

Hi Sergey,

I appreciate, Nice try. Please help me on this.

Regards,

AK

[sona_sa]

Hi Sergey,

Hope you got my point or please let me know if there is any more doubts is there.

Regards,

AK

[Sergey_Shuklin]

If I understood you correct you need to split data in the row to seven fields. But some data may be skipped so we have to use a mask like 'TestEnvironmentSim' for indicating a correct output field (OPERATOR and so on).

Right?

[Sergey_Shuklin]

Anyway, here is the sample.