variable help please

[Former Member]

hii i have a column with the following values

open

close

online 56743

target To: 453 min

from|:345 To: 22

offline

target

.

.

.

so now i need the values as

open

close

online 56743

453 min

22

offline

target

.

which means the values after "To:" has to be displayed and remaining columns should be the same

please help in this..

Thanks in Advance,

[Former Member · Accepted solution]

Hi,

try this

[new col =Trim( If(Pos([text];"To:")>0;Substr([text];Pos([text];"To:")+3;Length([text])-Pos([text];"To:"));[text]))

Where [text] is your column.

Regards,

Rogerio

[Former Member · Accepted solution]

thanks a lot Rogerio

[Former Member · Accepted solution]

Hi Rogerio,

could you  help in this please

i have a column

A

From: Yes To: No;

To:gtt;

To:gnr;

To;343;

From: vanguard To: vanguard;

To:343;

CNRBEL3

2TBGENCODE

2TBGH

From:bbhj;

,,,,

so i need 3 columns as

B

From: Yes

From: vanguard

CNRBEL3

2TBGENCODE

2TBGH

From:bbhj;

,,,,

C

To: No;

To:gtt;

To:gnr;

To;343;

To: vanguard;

To:343;

CNRBEL3

2TBGENCODE

2TBGH

,,,,

D

CNRBEL3

2TBGENCODE

2TBGH

,,,,

in first column only the values containing "From" till To and the remaining same and in second only from "To" and remaining same and in third only other values excluding both" From" and "To"

please help in this..

thanks in advance