text functions

[ilanbaruch]

hi,

I have a field in a table that holds information ..

output example:

<Account=jack johns>,<ResolvedIP=111.222.44.333>,<ResolvedCountry=AA>

I need only the ResolvedIP Value (111.222.44.333)

any idea how can I exclude it and create an IP field?

thank you

Ilan

[effinty2112]

Yet another solution that cares not the order of the terms in the angle brackets:

=SubField(

Right(TextToBeScanned,

Index(TextToBeScanned, 'ResolvedIP=') + len('<ResolvedIP=')+1)

, '>',1)

[ilanbaruch]

hi,

thank you for your help, can I set as input the original field?

[ilanbaruch]

hi,

thank you for your help, can I set as 'TextToBeScanned' the original field?

[effinty2112]

Hi Ilan,

               Yes replace 'TextToBeScanned' with your field. Sorry if I was not very clear.

Cheers

Andrew

[Kushal_Chawda]

Yes, You can replace Input with your actual field name

[ilanbaruch]

hi and thank you,

in sol1 can I use the field instead of the string (<Account=jack johns>,<ResolvedIP=111.222.44.333>,<ResolvedCountry=AA>')?

like this:

PurgeChar(SubField(INFO,',',2),'<ResolvedIP=<>,');