Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Find out the field and value from STRING

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

17 Replies
sona_sa
Creator II
Creator II
Author

Hi Buddy,

Any solution ? Please ...

Sergey_Shuklin
Specialist
Specialist

Hello!

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

sona_sa
Creator II
Creator II
Author

Hi Sergey,

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


Regards,

AK

Sergey_Shuklin
Specialist
Specialist

Like this way?

sona_sa
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Hi Sergey,

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

Regards,

AK

sona_sa
Creator II
Creator II
Author

Hi Sergey,

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

Regards,

AK

Sergey_Shuklin
Specialist
Specialist

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
Specialist
Specialist

Anyway, here is the sample.