requirement

[Anonymous]

i have a requirement :

I have below data:

field1	field2
123	123:None
456	456:None
345	345:None

now the values in colfield2 should be replaced with none ,

how to do that

[Anonymous]

Can you try

Purgechar(field2,'0123456789:') as newField

[antoniotiman]

SubField(field2,':',-1)

[Anonymous]

i have a requirement :

I have below data:

field1	field2
123	123:None
456	456:None
345	345:None

now the values in colfield2 should be replaced with NULL,

how to do that

[Anonymous]

On what condition it should be null?

[prashantsanchet]

SubField(field2,':',-1)

[antoniotiman]

Null() as field2

[Anil_Babu_Samineni]

Simply

Null() as FieldName OR

'' as FieldName

Not sure 100% i followed you?

[Anonymous]

try this,,,

NullTable:

Mapping Load None , Null() autogenerate 1;

Map subfield(Field2,':',2) using NullTable;

should be loaded before your original table...

[Anonymous]

filed2 displays value in above format against field1

so field 2 values should be null