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 Sergey,

Thanks for help. Can you share u'r mail id.

Lots of thanks.

Regards,

AK

[sona_sa]

Hi Sergey,

RAT1 and RAT2, Both are one filed - That is RAT.

Can u make a correct for the same.

Regards,

AK

[Sergey_Shuklin]

You can change the mask condition in wildmatch function.

P.S.: email - pt1346@mail.ru

[sona_sa]

Hi Sergey,

Thanks for reply,

Every thing is fine, But one thing i.e - For Result_field --> V_AREA,

In fld column I want V_AREA, Location, Operator and vl column I need all the fld data --> DFT, FT, OPIOT etc.

Please find the attached qvw.

Also if it is possible Please for all V_AREA --> remove all -, _ etc, I need only first charactor value, no any numeric like - DFT2040105, DFT2070201 etc --> DFT , For FT-RT-RB-1, FT_1.3 etc --> I need only FT, Similarly for other.

Regards,

AK

[sona_sa]

Hi Sergey,

Thanks for reply,

Every thing is fine, But one thing i.e - For Result_field --> V_AREA,

In fld column I want V_AREA, Location, Operator and vl column I need all the fld data --> DFT, FT, OPIOT etc.

Please find the attached qvw.

Also if it is possible Please for all V_AREA --> remove all -, _ etc, I need only first charactor value, no any numeric like - DFT2040105, DFT2070201 etc --> DFT , For FT-RT-RB-1, FT_1.3 etc --> I need only FT, Similarly for other.

Regards,

AK

[sona_sa]

Hi Sergey,

I hope you got my point, For ref. please find the attached .xls for final output. You will got my point.

Thanks & Regards,

AK

[Sergey_Shuklin]

Hello!

All your current requests can be done with the same functions which have been already used:

Replace(), Subfield(), Index() and so on.

The topic was solved - values inside the row were separated. Some other cosmetical issues, I think, can be done by your own.

[sona_sa]

Hi Sergey,

Last this is pending, I tried but got the same output.

Regards,

AK